Differences

This shows you the differences between two versions of the page.

--- transformations:exportexcel [2024/10/23 17:37] – add number formatting note craigt
+++ transformations:exportexcel [2025/06/28 12:33] (current) – update icon, title craigt
@@ Line 1: / Line 1: @@
-{{ transformations:ExportExcelAction.png}}
+{{ transformations:ExportIntoExcelAction.png}}
-====== EXPORT INTO EXCEL SPREADSHEET ======
+====== EXPORT INTO EXCEL FILE ======
 Category: Export / File\\
 \\
 =====Description=====
-This action exports the current dataset as a new Excel workbook (.xlsx) file, or //into// and existing Excel file, and supports the following modes:
+This action exports the current dataset as a new Excel workbook (.xlsx) file, or //into// an existing Excel file, and supports the following modes:
   * Create new file
@@ Line 16: / Line 16: @@
 You can subdivide a dataset and export it to a multi-tabbed Excel file using iterations and passing the sheet names in using Parameters in the called module.
-In conjunction with the [[transformations:excelcommand|Excel command]] action, it is possible to generate reports by dynamically updating the source data tables for charts and pivottables in an Excel file, and output to PDF fileS.
+In conjunction with the [[transformations:excelcommand|Excel command]] action, it is possible to generate reports by dynamically updating the source data tables for charts and pivottables in an Excel file, and output to PDF files.
 \\
@@ Line 22: / Line 22: @@
 ^ Setting  ^ Description  ^
 |File<sup>*</sup>|Enter a fully-qualified file name for the output file (includes relative or absolute path).  |
-|Mode|Select whether this action will create a new file, create a new sheet in an existing file,\\ or replace a sheet or range in an existing file .  See the table below for details.|
+|Mode|Select whether this action will create a new file, create a new sheet in an existing file,\\ or replace a sheet or range in an existing file.  See the table below for details.|
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]] or the first value of a column .\\
@@ Line 67: / Line 67: @@
 |Overwrite|The new file replaces the original file.|
 |Rename|The original file will be renamed with "backup" and a serial number appended to the file name.  The new file will\\ possess the name specified in the //File// setting.|
-|Halt project execution|The project will stop processing and this action will display a warning symbol.|
+|Halt project execution|The project will stop processing, and this action will display a warning symbol.|
 \\
 =====Remarks=====
 ====Close target workbooks before running====
-When //creating a new sheet// or //replacing a sheet/range//, or //overwriting an existing file//, the target file must be closed prior to running this action or it will result in a warning and no content will be written.  Close the target file and rerun this action to complete it successfully.\\
+When //creating a new sheet// or //replacing a sheet/range//, or //overwriting an existing file//, the target file must be closed prior to running this action, or it will result in a warning and no content will be written.  Close the target file and rerun this action to complete it successfully.\\
 \\
 ====Worksheet positioning====
@@ Line 83: / Line 83: @@
 \\
 ====Number formatting====
-This action formats numbers in spreadsheets according to their number formatting in EasyMorph.  For example, percentages will appear as percentages rounded values will appear as rounded values, etc.
+This action formats numbers in spreadsheets according to their number formatting in EasyMorph.  For example, percentages will appear as percentages, rounded values will appear as rounded values, etc.
 \\