Save Data Table To Excel File Step

Brief description

This step saves the data from the Data Table variable to the defined excel file.

Step Information

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

Input parameters

• Datatable variable name (Required)– existing variable name of datatable data type that contains the input value
• File Path (Required)– existing variable name or value that specifies the full path to excel file
• Sheet name (Required)– existing variable name or value that specifies the sheet name

 Additional comments

If file at the defined File path folder does not exist, file will be created containing the data from the datatable variable at the defined sheet name.

If file at the defined File path folder exist, it must contain the specified sheet name.

At the first row of the excel file sheet column names are saved. The data values are saved starting from the second row of the specified excel file sheet.