Excel File
- 03 May 2023
- 1 Minute to read
- Print
- DarkLight
Excel File
- Updated on 03 May 2023
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Description
The Excel File Export node exports a data set to an Excel file.
Configuration Options
Basic Configuration Options
| Setting | Description\Parameters |
|---|---|
File Name | Location of the file to export. The path can either be entered manually here or selected using the File Browser. |
Sheet Name | Name of the sheet to export data to. Can be parameterized. |
Clear Sheet Contents | If the target sheet already exists, this option can be set to clear out the sheet before exporting any data. Otherwise, it will write to an existing sheet, only overwriting data in the target range. |
Start Cell | Cell reference in A1-style notation that represents the top-left corner of the range to create. Can be parameterized. |
First Row is Header | Specifies if the first row in the file should be loaded as row header metadata. If this box is checked, the first row is loaded as header metadata. |
Decimal Places | Specifies the number of decimal places to which any Double data type columns will be truncated. |
Actions
| Action | Description |
|---|---|
Browse | Opens the File Browser Dialog where an export file can be selected for the node to use. |
Run | Once the node is configured, the output can be run at any time. |
File Browser Dialog
The Browse button opens the File Browser dialog where a source file can be selected for the node to use.
The Root Directory is the full path to the location of the source file. After entering a path, push the refresh button to update the list of relevant files based on the File Type filter.
After clicking on a file, it will be added to the File Name input box. Click the Open button to return to the main dialog.
Was this article helpful?