transformations:exportexcel
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:exportexcel [2021/05/12 11:31] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== EXPORT INTO EXCEL SPREADSHEET ====== | ||
+ | Category: Export / File\\ | ||
+ | |||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action exports a table into an Excel spreadsheet (.xlsx) file. The file name can use either a full or relative path.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | 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.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^ Setting | ||
+ | |File< | ||
+ | |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.| | ||
+ | |File already exists|When selecting to " | ||
+ | |Sheet name< | ||
+ | |Sheet or range< | ||
+ | |Create named range|When " | ||
+ | < | ||
+ | \\ | ||
+ | ====Export mode options==== | ||
+ | ^Option ^Description ^ | ||
+ | |Create new file|Create a new Excel file or overwrite an existing file with the same name. See the "File already exists\\ options" | ||
+ | |Create new sheet in existing file|This option will export the dataset to a new sheet inserted into the existing file selected in the //File//\\ setting, above.| | ||
+ | |Replace sheet/range in existing file|This option will output the dataset to an existing sheet or named range within the file selected in the\\ //File// setting, overwriting its content.| | ||
+ | \\ | ||
+ | ====File already exists options==== | ||
+ | ^Option ^Description ^ | ||
+ | |Overwrite|The new file replaces the original file.| | ||
+ | |Rename|The original file will be renamed with " | ||
+ | |Halt project execution|The project will stop processing and this action will display a warning symbol.| | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | If you're " | ||
+ | |||
+ | When creating a new sheet in an existing file, the new sheet will appear in the rightmost (last) position. | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | |||
+ | * [[transformations: | ||
transformations/exportexcel.txt · Last modified: 2022/01/31 14:21 by craigt