Documentation

Convert Excel to CSV Command: convertExceltoCsv

The convertExceltoCsv command under the File Handler function is used to convert an Excel file into a CSV file.

Example: You have an Excel file containing report data and need it in CSV format for database import.

Steps to Configure:

1. Select Set a Variable from the Action dropdown.
2. Enter a variable name in the Element Key field (e.g., CsvFilePath). This variable will store the path to the converted CSV file.
3. Click on Form to open the configuration window.
4. Select Functions from the dropdown, then choose File handler Functions.
5. In the Cmd field, select convertExceltoCsv.
6. Provide the following parameter:
   • File: Path to the Excel file to be converted (e.g., C:/Data/InputFile.xlsx).
   • Sheet: The Excel sheet number to be converted (e.g., 1 for the first sheet).
7. Click Save.

Outcome on execution:

• The specified sheet of the input Excel file is successfully converted into a CSV file.
• The path to the newly created CSV file is returned and stored in the variable defined in the Element Key. This variable can be used in later steps of your automation process to reference the stored information using the syntax ${VariableName} (e.g., ${CsvFilePath}).