Action group: Excel
Action shows hidden columns in Excel file
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 column 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 column 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 | |
None.
There is an Excel document.
You need to show columns A and B using the "Show columns" action.
Implementation of the action requires the following actions - "Open", "Show columns", "Save", "Close".
2. Set the parameters in the "Open" action.
3. Set the parameters of the "Show columns" action.
4. Set the parameters in the "Save" action.
5. Set the parameters in the "Close" action.
6. Click on the "Start" button and see the result.
The specified columns are shown.
