Action group: Excel
The action hides columns in the Excel file
| 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 | |
Hides all columns in the range from "From" to "To" (or vice versa if the "To" field is filled and the value is greater than "From").
If only the column name "From" is set, one column will be hidden.
You have an Excel document:
Hide columns A and B using the "Hide columns" action.
To implement the action the following actions are needed - "Open", "Hide columns", "Save", "Close".
2. Set the "Open" action parameters
3. Set the "Hide columns" action parameters
4. Set the "Save" action parameters
5. Set the "Close" action parameters.
6. Click "Start" and see the result.
The set columns are hidden.
