История страницы
...
The action hides columns in the Excel file.
Action icon
Action parameters
Input data
"Context" field - action context for working with an Excel document.
"Starting column name" field - the name of the starting column in the range to be hidden. 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, then the value from the «Starting column index» field is taken.
"Starting column index" field - the index of the starting column in the range to be hidden. 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 end column in the range to be hidden. If the field is not filled, then the value from the «Final column index» field is taken.
"final column index" field - the index of the end column in the range to be hidden. If the field is not filled, then a single column will be hidden.
Settings
| Property | Description | Type | Filling example | Mandatory field |
|---|---|---|---|---|
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Starting column name | The name of the starting column in the range to be hidden. 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, then the value from the «Starting column index» field is taken. | Robin.String | No | |
| Starting column index | The index of the starting column in the range to be hidden. If the specified column is not hidden, the action will display a warning. It will not terminate with an error. | Robin.Numeric | No | |
| Final column name | The name of the end column in the range to be hidden. If the field is not filled, then the value from the «Final column index» field is taken. | Robin.String | No | |
| Final column index | The index of the end column in the range to be hidden. If the field is not filled, then a single column will be hidden. | Robin.Numeric | No | |
...
You have an Excel document. :
Hide columns A and B using the "Hide columns" action.
...
Обзор
Инструменты контента