Converting CSV to an Excel FileLast Updated: 08/11/2016 Introduced in Verision: 2.0
In the example, we will create a flow that converts the data in a CSV file to an Excel format. A form will help perform the action. The form, Convert CSV to Excel, was created for this example.
Begin in the portal by navigating to a Designer Folder, and clicking the Create Flow button.
In the resulting New Flow pop-up, name the flow and click the OK button to open it in the Flow Designer.
Select a Convert Csv To Excel component from the Flow Designer’s start-up window, fro All Steps [Catalog] > Data > List > Excel and CSV category. Click Add to add this step to the workspace.
To configure this component, click on the Convert CSV to Excel step and select the Show Mapping Editor link in the Properties panel.
Next, map the inputs. For input, select a mapping type of Constant and click the Value selector.
In the resulting Open pop-up, select the CSV file to be converted and click Open.
In the Mapping Editor, map ConvertCsvToExcel1_Output to text and click OK to close the Mapping Editor.
This completes our example flow. To see it in action, click the Debug Flow link at the top of the window.
Note that in Decisions version 3.5 and above, you’ll need to click on Test Flow to access the Debugger.
In the resulting Save As pop-up, we will provide a name for the new Excel file and click Save.
An alert will notify us that the new file was saved to the local machine.
Under the Diagram tab, we will see that flow completed successfully.