Excel File
- 13 Jan 2023
- 1 Minute to read
- Print
- DarkLight
Excel File
- Updated on 13 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 Source Node is used to import data from Excel files.
Configuration Options
Basic Configuration Options
| Setting | Description\Parameters |
|---|---|
File Name | Location of the file to import. 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. Can be parameterized. |
Sheet Name | Name of the sheet to source data from. Can be parameterized. |
Use Named Range | Source data from a named range, or a range explicitly defined on cell references. |
Named Range | Name of the range to use as a source. |
Start Cell | Cell reference in A1-style notation that represents the top-left corner of the range to use. Can be parameterized. |
End Cell | Cell reference in A1-style notation that represents the bottom-right corner of the range to use. 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. |
Stay Within Bounds | Override to read all sheet data to the bottom of the sheet; ignores the bottom row set by the named range/end cell. |
Advanced Configuration Options
Click the
Data Type Assignmentbutton to view these options
| Setting | Description |
|---|---|
Column Data Type | This setting can be overridden. |
Actions
| Action | Description |
|---|---|
Infer Data Types | Automatically infer the data types used for each column. These data types can be overridden in the advanced section. |
Browse | Opens the File Browser Dialog where a source file can be selected for the node to use. |
Preview | Once the node is configured, the source data can be previewed at any time. Be sure to Infer Data Types. |
Preview Entire Sheet | After configuring the file/sheet, the source sheet can be previewed by clicking the Preview Entire Sheet button. |
Data Type Assignment | Navigates to the advanced section where you can override data types. |
File Browser Dialog
The Browse button opens the File Browser dialog where a source file can be selected for the node.
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.
Selecting a file populates the File Name input box. Click the Open button to return to the main dialog.
Was this article helpful?