Converting an Excel File to CSV

Overview

The Convert Excel to CSV component converts Excel-formatted tabular data to CSV format.

Example

1. From a Designer Project in the Decisions Studio, click the CREATE FLOW button, select Flow, provide a Name, and click CREATE.
2. From the Toolbox tab, attach a Convert Excel To Csv step from the DATA > EXCEL AND CSV category, to the Start step. 
3. Navigate to the newly added step's Properties tab, and select Edit Input Mappings.
4. Change the mapping of Input to Constant, then click Choose File; select the desired Excel file, then click Open.
5.  Change the mapping for Ignore First Line and Skip Blank Line to Constant and set both Inputs to True. 
6. Constant map the Type; select Csv from the dropdown menu. Then click OK. 
7. Back in the Flow Designer, attach a Show Form step from the FAVORITE STEPS category of the Toolbox tab, to the Done path of the Convert Excel File step; navigate to the Show Form step's Properties, click PICK OR CREATE FORM, then CREATE a new Form.
8. From the Form Designer, attach a Button component from the Toolbox, with the Button Text "Close."
9.   Add a File Download component from the Toolbox; set Select Button Type to Button.
   This Button will serve as the link to download the converted Excel File. Label it accordingly by changing the Text and Data Name to something like "Download CSV File."

   

10. Save the Form, then close the Form Designer via X.
11. Back in the Flow Designer, connect the Close path to the End step.

12. Navigate to the Properties tab for the Form step, map ConvertExcelToCsv1_Output to Download CSV File.

13. Save the Flow, then if desired, close the Flow Designer. 

Debug

1. From the Flow Designer, click the Debug link in the top action bar. 
2. Once the Flow runs, on the Form, click the Download CSV File button, then click Close.
3. Check the downloaded file to verify that it was successfully converted to a CSV file.