Skip to main content

Excel to CSV

Converts an Excel file's Sheets into CSV files

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 ContinueOnError property is true, no error is caught when the project is executed even if Catch node is used.

Input​

  • Excel Path - The full path of the Excel file to convert (e.g. C:\MyPath\MyExcel.xlsx)
  • Out CSV Path - The path for the resulting CSV files' directory (e.g. C:\MyPath\CSVFiles\)
info

There will be multiple CSV files if the Excel has more than one Sheet

Output​

  • Files Path - Craeted CSV file paths (e.g. ["C:\MyPath\CSVFiles\Sheet1.csv","C:\MyPath\CSVFiles\Sheet2.csv"])

Options​

  • Separator - The separator character to be used in CSV files. Possible values: Comma (,), Semicolon (;), TAB, Space. The default value is Semicolon (;).