Show columns Version 1 (Python)

Action group: Office

Description

The action shows the hidden columns.

Action icon


Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with ods/xlsx table.Robin.OpenSheetD oc
Yes
Starting column nameThe name of the starting column in the range of columns to be displayed. If the field is not filled in, the starting column will be determined by the value from the «Starting column index» field. If neither the name nor the index of the starting column is specified, the action will fail.Robin.String
No
Starting column indexThe sequence number of the starting column in the range of columns to be displayed. The numbering starts from 1.Robin.Numeric
No
Ending column nameThe name of the ending column in the range of columns to be displayed. If the field is not filled in, the starting column will be determined by the value from the «Ending column index» field. If neither the name nor the index of the destination column is specified, the range will be limited to the starting column only.Robin.String
No
Ending column indexThe sequence number of the ending column in the range of columns to be shown. The numbering starts from 1.Robin.Numeric
No

Special conditions of use

None.

Example of use 

Task

There is a tabular document in which columns B and C are hidden. It is required to make them visible.

Solution

Use the actions "Open", "Show columns", "Save"

Implementation

  1. Assemble a robot scheme consisting of actions:

2. Set parameters for the "Open" action. In the "Path to file" field specify the path to the required tabular document "Test 1".

3. Set the parameters for the "Show columns" action. 

    1. In the "Context" field specify the context of the opened document "Test 1".
    2. In the "Starting column name" field, specify the name of the starting column in the range of columns to be displayed.
    3. In the "Ending column name" field, specify the name of the ending column in the range of columns to be displayed.

4. Set the parameters of the "Save" action. In the "Context" field specify the context of the opened document "Test 1"

5. Launch the robot using the "Start" button in the top panel. 

Result

The program robot completed successfully.

The required columns are displayed in the document.