Excel To Data Table Step

Brief description

This step loads data from an Excel file into a DataTable variable. Optionally, users can define custom column names and data types for the resulting DataTable.

Step Information

Step name (Not required) – the custom name of the process step that labels the editor’s process step box

Input parameters

• Excel Path (Required)– existing variable name or value that specifies the full path to excel file
• Sheet (Required)– existing variable name or value that specifies the sheet name
• Has custom columns (Required) - has header columns
  • T (true)
  • F (false- default value)

Output parameters

• Result Datatable (Required)– existing or new variable name of datatable data type that contains the resulting value. If a new DataTable variable is created, you may optionally define Custom Columns for it (this is not required).
  • Column Name – the desired name for the output column
  • Column Type – the .NET data type for the column (e.g., String, Integer, Decimal, DateTime, Boolean, etc.)
• Column count (Required)– existing or new variable name of integer data type that contains the resulting data table variable count of columns 
• Row count (Required)– existing or new variable name of integer data type that contains the resulting data table variable count of rows 

Additional comments

The number of custom columns must exactly match the number of columns in the resulting data table. For example, if the resulting data table contains four columns, you must define exactly four custom column definitions. Defining fewer or more columns will result in an error.

Additionally, if the selected data type for any custom column does not match the actual data contained in that column, the system will return a type conversion error.