Action group: Excel Clear range
Action icon
Version:
- 8 (net)
Action removes values from the specified range
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 start cell (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 start cell (beginning 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 | Row of the starting 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 row (end of range) from which the area to be deleted will be set. | Numeric | No |
Version:
- 7 (net)
Action removes values from the specified range
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 of the start cell (start of the range) from which the area to be deleted will be set. | String | No | |
Start cell row | Row of the start cell (start of the range) from which the area to be deleted will be set. | Numeric | No | |
End cell column name | The column of the end cell (end of range) from which the area to be deleted will be set. | String | No | |
End cell row | Row of the end cell (end of range) from which the area to be deleted will be set. | Numeric | No |
Version:
- 6 (net)
- 5 (net)
- 4 (net)
- 3 (net)
- 2 (net)
- 1 (net)
Action removes values from the specified range
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 | Address of the start cell (beginning of the range) from which the area to be deleted will be set. Fill in the format "XY", where "X" is the column number and "Y" is the row number. The "R1C1" reference style is not supported. | String | No | |
End cell | Address of the end cell (end of the range) from which the area to be deleted will be set. Fill in the format "XY", where "X" is the column number and "Y" is the row number. The "R1C1" reference style is not supported. | String | No |
Обзор
Инструменты контента