Set range formula Version 1 (Net)
Action group: Excel
Description
The action allows you to execute a formula in a selected range in an Excel document.
Icon
Settings of parameters
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 row | The number of the line from which the formula will be applied. | Numeric | No | |
Start column name | The name of the column from which the formula will be applied. If the field is not filled in, the value from the "Start column index" field is taken. | String | No | |
Start column index | The index of the column starting from which the formula will be applied. If the field is not filled in, the initial boundary of the used area will be taken. | Numeric | No | |
End row | The number of the line to which the formula will be applied. | Numeric | No | |
End column name | The name of the column to which the formula will be applied. If the field is not filled in, the value from the "End column index" field is taken. | String | No | |
End column index | The index of the column to which the formula will be applied. If the field is not filled in, the final boundary of the used area will be taken. | Numeric | No | |
Formula | A formula to be applied to the specified range. The formula starts with the "=" symbol. | String | Yes | |
Local language | If true, the formula will be read in the local language, otherwise it will be read in English. | Boolean | true | No |
Register | If the value is "true", the formula remains unchanged, otherwise - all letters will become capitalized. | Boolean | true | No |
Skip hidden | If true, no formula will be applied to the hidden cells. | Boolean | true | No |
Special conditions of use
- The formula will also be calculated in the merged cell.
- If a range of only hidden cells is specified and the "Skip hidden" field is true, there will be no ** error. The action will simply not apply the formula anywhere. If only part of the range is hidden, the formula will apply to the available cells.
- If the optional area fields are not filled in, the formula will be applied to the entire used area of the sheet.
- If the search range is not restricted to columns, the formula will be applied to all columns of the used area within the range of the specified rows.
- Priority is given to the "Column name" field if both the "Column name" and "Column index" fields are filled.
- If only the row/column start index is filled, the range will start with that index and end with the last row/column of the data area.
- If only the row/column end index is filled, the range will start with the first row/column of the data area and end with that index.
- To select only 1 row/column, you must specify the same thing in both the start name/index and end name/index.
The robot will return an error if:
- negative row indices or 0;
- column name is entered incorrectly.
The robot will NOT return an error if:
- a range outside the table workspace is selected, it will simply fill the cells in the specified range.
Example of use
Task
Execute a formula for a range of cells in Excel.
Solution
Use the actions "Open", "Set range formula", "Save".
Implementation
- Assemble a robot scheme consisting of actions:
- Customize the settings for the "Open" action.
- Configure parameters for the "Set range formula" action.
- Customize the settings for the "Save" action.
- Click on the "Start" button in the top panel.
Result
The program robot completed successfully.
A given formula is executed in a given range.
Обзор
Инструменты контента