Skip to main content

Excel To Data Table

Converts an Excel file to a data table format.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Excel File Path - The file path to the Excel file to be converted.

Options​

  • Output Type - Specifies whether to pass the table by reference or by value. Options are:
    • Pass By Reference
    • Pass By Value

Output​

  • Table - The resulting data table converted from the Excel file.

How It Works​

The Excel To Data Table node reads an Excel file and converts it to a data table format. When executed, the node:

  1. Validates that the Excel file path is not empty
  2. Checks if the Excel file exists at the specified path
  3. Reads the Excel file using pandas
  4. Replaces any NaN values with empty strings
  5. Converts the data to a dictionary format with columns and rows
  6. Returns the data table

Requirements​

  • A valid Excel file path
  • The Excel file must exist at the specified location
  • Proper file system permissions to read the file

Error Handling​

The node will return specific errors in the following cases:

  • Empty Excel file path
  • Excel file does not exist at the specified path
  • Invalid Excel file format
  • Insufficient permissions to read the file

Usage Notes​

  • The Output Type option can be set to "Pass By Reference" for handling large Excel files more efficiently
  • NaN values in the Excel file are automatically converted to empty strings
  • The first row of the Excel file is used as column headers
  • The node supports standard Excel formats