Delete Cell

The Delete Cell activity allows you to clear cell contents 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.

clear-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 the 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. Select how to specify the sheet in the Excel file where you want to clear the cell contents:

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

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