Excel File
- 06 Jan 2023
- 1 Minute to read
- Print
- DarkLight
Excel File
- Updated on 06 Jan 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 node is used to export a data set to an Excel file.
Configuration Options
Basic Configuration Options
| Setting | Description\Parameters |
|---|---|
File Name | Location of the file to export. This is the full path to the file, including the drive on which it lives. 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 can be set to clear out the sheet before exporting any data. Otherwise, will write to an existing sheet, only overwriting data in the target range. |
Start Cell | Cell reference in A1-style motation 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 will be 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. This dialog can be used to find an export file for the node to use. |
Run | After configuring the node, the output can be run by clicking the Run button. |
File Browser Dialog
The Browse button opens the File Browser dialog. This dialog can be used to find a source file for the node to use.
The Root Directoryis 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?