Get Cell

The Get Cell activity allows you to extract cell values when working with Microsoft Excel tables.

Activity settings

To open the settings window, click on the activity on the process diagram.

Parameters Tab

The Parameters tab displays the basic activity parameters.

get-cell-value-1

Name. The activity name on the process diagram. It is set by the template when adding the activity. You can change the name if you need.

Path to Excel file. The Excel file location in the file system. When specifying the path, you can use process context variables that store the path or a part of the path. Click on the specify-variable-icon icon and specify the variable. You can select it from the list or add a new one by clicking Create parameter. This field supports only the String type variables. The value is inserted as {$variable name}. You can fill in the field manually following this format. For more information about context variables, see Process context.

Get sheet by. Define how to select the sheet in the Excel file where you want to extract the cell values:

  • Number. In the Sheet number field, specify the number of the sheet in the Excel file;
  • Name. In the Sheet name field, specify the name of the sheet in the Excel file.

Get several. Possibility to extract values from multiple table cells at once.

Cell addresses. Specify the address of the cell that you want to extract the value from. If you need to extract the values from the several cells, specify the cell range. For example, B2 or A1:C3.

When indicating the number, the sheet name, or the cell address, you can use values of the context variables. Click on the specify-variable-icon icon and specify the variable. You can select it from the list or add a new one by clicking Create parameter. This field supports only the String type variables. The value is inserted as {$variable name}. You can fill in the field manually following this format.

Parameter. A variable that will store the found cells values. You can select the variable from the list or create a new one by clicking the add-button button. This field supports only the String type variables. If you activated the Get several option, as a result, you will receive a string array storing values from several cells.

Conditions Tab

For more information about the Conditions tab, see Basic activity settings principles.

Found a typo? Highlight the text, press ctrl + enter and notify us