convertExcelToCSV Step
Description:
This step converts an Excel file (located on the app server) and creates a copy in CSV format.
Inputs
- inputFilePath--Path for the file on the App server
- outputFilePath-- Path for the file to be saved on the App server
Returns
- True – step executed successfully
- False – step failed to execute
Usage:
Example:
Let’s build and execute the “convertExcelToCSVDef” example.
- Create a new definition called “convertExcelToCSVDef” and open the definition in designer mode.
- Drag a “convertExcelToCSV” step to the canvas.
- Connect the dots between the “Start” and “convertExcelToCSV” steps, as shown above.
- Click the “convertExcelToCSV” step to configure its “Required” properties. Provide a name for the step. Provide the source path to the Excel file (on the app server). Provide the target path (on the app server) where the CSV file will be stored. Click the Save button. Note: Click the "AI Predict" button for the Copilot to add new process steps that match your process description.
- The “Logging” setting configuration is necessary for documentation and also measures the workflow progress and the percent complete. This is achieved by configuring the step state and percent fields individually, as shown below. Configure the “Logging” using the following properties.
- Save the process definition, create a new instance, and then execute it. Render the process instance.
- As configured, the process step should convert the Excel file to a CSV file in the path.
Definition Sample:
You may download the sample definition(s) from the link here and later import them (drag-and-drop) to your FlowWright Process Definition (XML file) or Form Definition (HTML file) page.
Note: Please verify and complete the process steps for any missing configurations, such as file path references and database connections, after import. Then, save the definition to confirm the changes.
Click here to download the sample file.