Differences

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

--- transformations:excelcommand [2022/01/31 13:07] – Add Re-save and Save to PDF modes. craigt
+++ transformations:excelcommand [2022/08/19 05:01] – [Description] dmitry
@@ Line 5: / Line 5: @@
 \\
 =====Description=====
-This action performs a process on an Excel file.
+This action performs a command on an Excel file.
   * List sheets/ranges
   * Run VBA macro
@@ Line 82: / Line 82: @@
 ^Setting^ Description  ^
 |PDF file<sup>*</sup>|Enter the fully qualified path and filename of the PDF file to be generated.|
-|If the PDF file already exists|Choose how EasyMorph will handle situations when the PDF file already exists.  Options:  //Overwrite// (replace the existing file), //Rename// (generate a new name for file being created), or //Halt project execution// (stop the workflow with a warning).|
+|If the PDF file already exists|Refer to the //File already exists options// table below for details.|
 |Page range|Choose which pages to include in the PDF file.  Options:  //All pages// (all pages in the select sheet will be exported to the PDF file), or //Pages// (and enter the starting and ending number of the pages to be exported).|
 |Sheets|Choose which workbook sheets will be exported to the PDF file.  Options:  //All sheets// (the content from all worksheets will be exported), or //Selected sheets// (select the sheets to include from the list).|
@@ Line 88: / Line 88: @@
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]] or the first value of a column.\\
+\\
+====File already exists options====
+^Option ^Description ^
+|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.|
 \\
 =====Remarks=====