Find Cell

The Find Cell activity allows you to find cells addresses by their 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.

find-cell-address-1

Name. The activity name on the process diagram. Its name is set by default when adding the activity. You can change the name in this field.

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 search for a cell address:

  • 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.

Search. Enter the value of the cell you want to find the address of.

When you indicate the number, the sheet name, or the cell value, 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.

Find all matches. If you want to find addresses of all cells with the specified value, select Yes. If you want to find an address of one particular cell, choose No.

Match case. If you want to use case sensitivity when searching for a cell address by value, select Yes.

Match entire cell contents. If you want to find cells values which completely match the entered characters, choose Yes. If you select No, the results will include values with partial matching.

Parameter. A context variable that will store the found cell address. You can select it from the list or add a new one by clicking the add-button button. This field supports only the String type variables. If you activated the Find all matches option, you will receive a string array storing cells addresses.

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