Converting CSV to an Excel File

Overview

The Convert CSV to Excel component converts CSV tabular data to the Excel 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 Csv To Excel 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 CSV 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 desired conversion Type by selecting an option from the dropdown menu.
7. Click OK.
8. 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 Csv File step; navigate to the Show Form step's Properties, click PICK OR CREATE FORM, then CREATE a new Form.  
9. From the Form Designer, attach a Button component from the Toolbox, with the Button Text "Close."
10. 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 CSV File. Label it accordingly by changing the Text and Data Name to something like "Download Excel File."

    

11. Save the Form, then close the Form Designer via X.

12. Back in the Flow Designer, connect the Close path to the End step. 

13. Navigate to the Properties tab for the Form step, map ConvertCsvToExcel1_Output to Download Excel File.

14.  Save the Flow, then if desired, close 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 Excel File button, then click Close. 
3. Check the downloaded file to verify that it converted to the correct File Type.