Excel File
- 06 Jan 2023
- 2 Minutes to read
- Print
- DarkLight
Excel File
- Updated on 06 Jan 2023
- 2 Minutes 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 from a range explicitly definined on cell references. |
Named Range | Name of the range to use as a source. |
Start Cell | Cell reference in A1-style motation that represents the top-left corner of the range to use. Can be parameterized. |
End Cell | Cell reference in A1-style motation 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 will be 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. This dialog can be used to find a source file for the node to use. |
Preview | After configuring the node, the source data can be previewed by clicking the Preview button. 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 will populate the File Name input box. Click the Open button to return to the main dialog.
Was this article helpful?