Clear range Version 9 (Net)

Action group: Excel 

Description

Removes values from the specified area.

Icon

Parameters

Input parameters  

NameDescription
ContextThe action context for working with an Excel document
Start cell column nameThe column name of the start cell (beginning of the range) from which the area to be deleted will be set
Start cell column indexThe column index of the start cell (beginning of the range) from which the area to be deleted will be set
Start cell rowThe row of the start cell (beginning of the range) from which the area to be deleted will be set
End cell column nameThe column name of the end cell (end of the range) to which the area to be deleted will be set
End cell column indexThe column index of the end cell (end of range) to which the area to be deleted will be set
End cell rowThe row of the end cell (end of range) from which the area to be deleted will be set

Settings

Property

Description

Type

Example of filling in

Obligatory to fill in the field

Parameters

Context

Action context for working with an Excel document

Excel instance

Excel context

Yes

Start cell column name

The column name of the initial cell (the beginning of the range) from which the area to be deleted will be set. If the field is not filled in, the value from the "Start cell column index" field is taken.

String


No

Start cell column index

The column index of the initial cell (start of the range) from which the area to be deleted will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

Start cell row

String of the initial cell (beginning of the range) from which the area to be deleted will be set.

Numeric


No

End cell column name

The column name of the end cell (end of range) to which the area to be deleted will be set. If the field is not filled in, the value from the "End cell column index" field is taken.

String


No

End cell column index

The column index of the end cell (end of range) to which the area to be deleted will be set. If the field is not filled in, the boundary of the area to be used is taken.

Numeric


No

End cell row

The end cell string (end of range) from which the area to be deleted will be set.

Numeric


No

Special conditions of use

The "R1C1" reference style is not supported.

Example of use

Task

There is an Excel document with a table:

 

Need to clear area 3 and 4 rows for Berlin and Vatican city. 

Solution

Use the actions "Open", "Clear range", "Save". 

Implementation 

  1. Assemble a robot scheme consisting of actions: 


  2. Customize the parameters of the "Open" action. In the "Path to file" field, specify the path to the required Excel file. Check the Visible = true checkbox to display robot actions on the screen. 


  3. Customize parameters of the "Clear range" action.  In the "Context" field specify the context of the opened document, specify the range from A3 to B4 in the corresponding fields. 


  4. Customize the parameters of the "Save" action. Specify the context of the Excel document in the "Context" parameter.


  5. Launch the robot using the "Start" button in the top panel. 

Result

The program robot completed successfully.

The target range is cleared.