Clear Cell in File

This is a pre-built action located under @Excel element, instructs Avo Assure to clear the content of a specific cell whose row and column number are specified in the input value and save the result in the dynamic variable.

Syntax

Input Value: <rowNum>;<ColNum>

Argument
Description

rowNum (Required)

Row number specifies which row in the file to clear the cell value

ColNum (Required)

Column number specifies which column in that row to clear the particular cell value

Output Value:

Argument
Description

<Dynamic Variable>(Optional);< Dynamic Variable>(Optional)

This variable holds the results in True and False

Example:

Clears the content of a specified cell in an Excel file using Clear Cell in File action

The Clear Cell in File action takes the value from the Input Value column (2;3) and clears the content of the specified cell located at row 2 and column 3 in the set Excel file. The status of the action is stored in the {Status} variable, with the following possible values:

  • True – if the cell is cleared successfully.

  • False – if clearing the cell fails.

Last updated

Was this helpful?