Show columns Version 10 (.Net)
Action group: Excel
Description
Action shows hidden columns in Excel file
Action 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 |
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 | |
Special conditions of use
None.
Example of use
Task
There is an Excel document.
You need to show columns A and B using the "Show columns" action.
Solution
Implementation of the action requires the following actions - "Open", "Show columns", "Save", "Close".
Implementation
- Assemble a robot scheme consisting of actions:
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.
Result
The specified columns are shown.
Обзор
Инструменты контента