История страницы
...
Action parameters
Input parameters
- “"Context” " field - The context of the action for working with the Excel document.
- “"Starting column name” " field - The name of the starting column in the range that will be shown. If the specified column is not hidden, the action will display a warning. It will not terminate with an error. If the field is not filled in, the value from the “Starting "Starting column index” index" field is taken.
- “"Starting column index” " field - The index of the starting column in the range to be displayed. If the specified column is not hidden, the action will display a warning. It will not terminate with an error.
- “"Final column name” " field - The name of the final column in the range to be shown. If the field is not filled in, the value from the “Final "Final column index” index" field is taken.
- ”"Final column index” " field - The index of the final column in the range that will be shown. If the field is not filled in, one column will be hidden.
...
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 |
Starting column name | The name of the starting column in the range to be displayed. If the specified column is not hidden, the action will display a warning. It will not terminate with an error. If the field is not filled in, the value from the “Starting "Starting column index” index" field is taken. | String | НетNo | |
Starting column index | The index of the starting column in the range to be displayed. If the specified column is not hidden, the action will display a warning. It will not terminate with an error. | Numeric | НетNo | |
Final column name | The name of the end column in the range to be displayed. If the field is not filled in, the value from the “Final "Final column index” index" field is taken. | String | НетNo | |
Final column index | The index of the final column in the range to be shown. If the field is not filled in, a single column will be shown. | Numeric | НетNo | |
Special conditions of use
...
You need to show columns A and B using the “Show columns” "Show columns" action.
Solution
Implementation of the action requires the following actions - “Open”, “Show columns”, “Save”, “Close”"Open", "Show columns", "Save", "Close".
Implementation
- Assemble a robot scheme consisting of actions:
...
2. Set the parameters in the “Open” "Open" action.
3. Set the parameters of the “Show columns” "Show columns" action.
4. Set the parameters in the “Save” "Save" action.
5. Set the parameters in the “Close” "Close" action.
6. Click on the “Start” "Start" button and see the result.
...
Обзор
Инструменты контента