Map Excel cells to variables

Use this step to map Excel cells to the variables or globals.

Last published at: September 9th, 2025

clsExcelToVarsGlobal Step

Description:

This step maps the Excel cells to the variables or globals. Note: The Excel file should be located in the application server's folder path. 

 

Inputs

  • inputFilePath – path to the Excel file
  • workSheetName - worksheet name
  • mapping - map Excel cell references to the variables or globals
 

 

Returns

  • True – step executed successfully 
  • False - step failed to execute 
 

 

 

Usage:

 

 

Example:

Let’s build and execute the “clsExcelToVarsGlobalDef” example:

  • Create a new process definition named “clsExcelToVarsGlobalDef” and open it in designer mode. 
  • Drag an “clsExcelToVarsGlobal” step to the canvas.
  • Connect the dots between the “Start” and “clsExcelToVarsGlobal” steps, as shown above. 
  • Click the "clsExcelToVarsGlobal" step to configure its "Required" properties. Provide a name for the step and the path to the Excel file. Click the button to create the mappings, then click Save. Note: Click the "AI Predict" button for the Copilot to add new process steps that match your process description. 

 

  • An image of the Excel file used in this example is shown below for reference. 

 

  • Click the button to create the mappings. A pop-up window appears for configuration. Click the Add Row (+) button to insert an empty row. Enter the Excel cell reference and a variable or global reference to store the value. Click the Save button. You can insert multiple mappings by using the Add Row button. 

 

  • Click the "clsExcelToVarsGlobal" step to configure its "Optional" properties. Enter the worksheet name. Click the Save button. 

 

  • The “Logging” configuration is necessary for documentation and also measures workflow progress and percent complete. This is achieved by configuring the step state and percent fields individually, as shown in the images below. Configure the “Logging” using the following properties.

 

  • Save the process definition, create a new instance, and execute it. Render the process instance. Click the process step to view its properties. The step should map the Excel cell values to the variables or globals as configured. 

 

 

Definition Sample:

You may download the sample definition(s) from the link provided and later import them (drag-and-drop) into 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.