История страницы
...
Action shows hidden columns in Excel file
Action icon
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 column 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 column 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.
...
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 |
...