icon-phone530-820-3390 530-820-3390icon-supportSupport

Documentation

Excel To Xml Action: exceltoxml

The exceltoxml action converts an Excel file into an XML format, allowing seamless integration with systems that require XML data structures. This function is ideal for exporting structured data for further processing or sharing.

Note: Ensure that the file being used is not open during the Case execution to avoid errors or conflicts.

Example: You have an Excel file named productCatalog.xlsx and need to convert it into an XML file saved at C:\Exports\productCatalog.xml.

Steps to Configure:

  1. Add a new step.
  2. Select Set a Variable Value from the Action dropdown.
  3. Enter a variable name in the Element Key field (e.g., XMLConversionStatus). This variable will store the operation result (e.g., success or failure).
  4. Click on Form, select Functions, and choose EXCEL Handler Functions from the dropdown.
  5. In the Cmd field, select exceltoxml and provide the following parameters:
    • FPath: Specify the path to the Excel file to be converted (e.g., C:\Data\productCatalog.xlsx).
    • Xmlpath: Specify the destination path where the XML file will be saved (e.g., C:\Exports\productCatalog.xml).
  6. Click Save.
Tabular View
Card View

Outcome on Execution:

  • The action converts the specified Excel file to an XML file and saves it to the designated path.
  • If the operation is successful, the action returns true in the variable defined in the Element Key (e.g., XMLConversionStatus).
  • If the operation fails (e.g., invalid file paths or permission issues), it returns false.
  • This variable can be referenced in later steps of your automation process using the syntax ${VariableName} (e.g., ${XMLConversionStatus}).

Back To Top