Description:
This step reads values from CSV, Excel, and TXT file types.
Inputs
- inputFilePath - variable / global that holds the XLS / XLSX / CSV / TXT file path on the server
- mapCellDataToVariables - Map cell data to variables/globals
- worksheetName - Worksheet name (not mandatory) When blank, select the first worksheet name in the workbook / CSV; even the incorrect worksheet name refers to the first worksheet in the workbook / CSV.
Returns
- True – True condition
- False – False condition
Configure:
Navigate to Administration > Data Types > Utils > Auto Detect to open a new tab. Search for “clsCsvAndExcelDataMap” data type. If not found, then select “Actions > Create”.
A pop-up window appears for configuration. Enter the name, description, namespace, and DLL path as shown in the image below. Click the “Validate” button. The new data type configuration is validated, and a confirmation message appears in the top-right corner. Click the “Create” button to complete.
If the DLL is not present or the namespace is unavailable, select “Utils > Auto Detect”. The application shall locate the DLL to be configured manually. Consider upgrading the FlowWright application to the latest version if this DLL is not found.
Navigate to Administration > Steps > Utils > Auto Detect to open a new tab. Search for “readValuesFromCSVandExcel” process step. If not found, then select “Actions > Create”.
A pop-up window appears for configuration. Enter the step name, display name, description, index value, choose the category from the drop-down list, namespace, and DLL path as shown in the image below. Click the “Validate” button. The new data type configuration is validated, and a confirmation message appears in the top-right corner. Click the “Create” button to complete.
If the DLL is not present or the namespace is unavailable, select “Utils > Auto Detect”. The application shall locate the DLL to be configured manually. Consider upgrading the FlowWright application to the latest version if this DLL is not found.
Usage:
Example:
Let’s build and execute the “readValuesFromCSVandExcelDef” example.
- Create a new definition called “readValuesFromCSVandExcelDef” and open the definition in designer mode.
- Drag a “readValuesFromCSVandExcel” step to the canvas.
- Define a variable or a global to store the result.
- Connect the dots between the “Start” and “readValuesFromCSVandExcel” steps as shown above.
- Let's assume the XLSX file is available on the server path, with the sample data on the Sheet2 worksheet, as shown below.
- Click the “readValuesFromCSVandExcel” step to configure its “Required” properties. Provide a name for the step. Provide the path to the CSV or XLSX file or folder on the FlowWright server. Click the button to map the Excel/CSV data to process variables. Click the Save button. Note: Click the "AI Predict" button to have Copilot add new process steps that match your process description.
- Click the “readValuesFromCSVandExcel” step to configure its “Optional” properties. Enter the worksheet name.
- Map the Excel/CSV data to the variables or globals using Row and Column notation, as shown below.
- Save the process definition, create a process instance, and then execute it. When the process instance is completed, render it to view the step properties. This step should read the CSV and Excel values from the Sheet2 worksheet and initialize the process variables.
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 the import. Then, save the definition to confirm the changes.
Click here to download the sample file.