Documentation

Convert CSV to Xlsx Command: convertCsvtoXlsx

The convertCsvtoXlsx command under the File Handler Functions is used to convert a CSV file into an Excel (.xlsx) file format.

Example: Suppose you have a user data CSV file and need it in Excel format for reporting purposes.

Steps to Configure:

1. Select Set a Variable from the Action dropdown.
2. Enter a variable name in the Element Key field (e.g., FilePath). This variable will store the path to the converted file.
3. Click on Form to open the configuration window.
4. Select Functions from the dropdown, then choose File Handler Function.
5. In the Cmd field, select convertCsvtoXlsx.
6. Provide the following parameter:
   • File: Path to the CSV file to be converted (e.g., C:/Data/InputData.csv).
7. Click Save.

Outcome on execution:

• The input CSV file is successfully converted into an Excel (.xlsx) file.
• The path to the newly created Excel file is returned and stored in the variable defined in the Element Key (e.g., FilePath). This variable can be used in later steps of your automation process to reference the stored information using syntax ${VariableName} (e.g., ${ FilePath}).
• If the conversion fails (e.g., due to incorrect paths or file access issues), an error is returned.