transformations:exportexcel
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
transformations:exportexcel [2021/07/17 15:35] – craigt | transformations:exportexcel [2022/01/31 14:21] (current) – Add table references, Replace table mode, reformat. craigt | ||
---|---|---|---|
Line 5: | Line 5: | ||
\\ | \\ | ||
=====Description===== | =====Description===== | ||
- | This action exports a table into an Excel spreadsheet | + | This action exports |
+ | |||
+ | * Create new file | ||
+ | * Create new sheet in existing file | ||
+ | * Replace sheet/range in existing file | ||
+ | * Replace table in existing | ||
\\ | \\ | ||
=====Use cases===== | =====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.\\ | + | 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: | ||
\\ | \\ | ||
Line 16: | Line 23: | ||
|File< | |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.| | |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 "Create new file" in the option above, choose whether to overwrite | + | |
- | |Sheet name< | + | < |
- | |Sheet or range< | + | |
- | |Create named range|When | + | \\ |
- | < | + | ====Create new file settings==== |
- | \\ | + | Description: |
- | ====Export mode options==== | + | ^Setting ^Description ^ |
- | ^Option | + | |Sheet name< |
- | |Create new file|Create a new Excel file or overwrite an existing file with the same name. See the "File already exists\\ options" | + | |Create |
- | |Create new sheet in existing file|This option will export | + | |Create table|When checked, the dataset will be output into a formatted Excel table. |
- | |Replace | + | |
+ | < | ||
+ | |||
+ | \\ | ||
+ | ====Create new sheet in existing file settings==== | ||
+ | Description: | ||
+ | ^Setting ^Description ^ | ||
+ | |Sheet name< | ||
+ | |Create named range|When | ||
+ | |Create table|When checked, the dataset will be output into a formatted Excel table. | ||
+ | |||
+ | < | ||
+ | |||
+ | \\ | ||
+ | ====Replace sheet/range in existing file settings==== | ||
+ | Description: | ||
+ | ^Setting | ||
+ | |Sheet or range< | ||
+ | |||
+ | < | ||
+ | |||
+ | \\ | ||
+ | ====Replace | ||
+ | Description: | ||
+ | ^Setting ^Description ^ | ||
+ | |Sheet name< | ||
+ | |||
+ | < | ||
\\ | \\ | ||
====File already exists options==== | ====File already exists options==== | ||
Line 36: | Line 71: | ||
\\ | \\ | ||
=====Remarks===== | =====Remarks===== | ||
- | If you're "creating a new sheet" | + | ====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. | ||
+ | \\ | ||
+ | ====Worksheet positioning==== | ||
+ | When //creating a new sheet in an existing file//, the new sheet will appear in the rightmost position. | ||
+ | \\ | ||
+ | ====Replacing ranges and tables==== | ||
+ | When //replacing an existing range or table//, the content of the target Sheet will be cleared before the dataset is exported and named with the original range/table name. New ranges/ | ||
- | When creating a new sheet in an existing file, the new sheet will appear in the rightmost (last) position. | + | An error will occur if // |
\\ | \\ | ||
Line 49: | Line 91: | ||
=====See also===== | =====See also===== | ||
+ | * [[transformations: | ||
* [[transformations: | * [[transformations: | ||
+ | |||
transformations/exportexcel.txt · Last modified: 2022/01/31 14:21 by craigt