Set Cell

The Set Cell activity allows you to fill cells 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.

specify-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 add the cell value:

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

Cell address. Enter the address of the cell you want to fill. For example, B2.

When you indicate 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.

Value. Enter the value you want to fill the cell with.

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