Set Color

The Set Color activity allows you to set the cells colors 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.

set-cell-color

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 the format. Read more about process context variables in the "Process context" article.

Get sheet by. Define how to select the sheet in the Excel file where you want to set the color for the cells:

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

Cell address. Enter the address of the cell you want to change the color of. 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 the format.

Select color. Choose the color to highlight the specified cell.

Conditions Tab

Read more about the Conditions tab in the "Basic activity settings principles" article.

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