Hide rows Version 1 (Python)

Action group: Office

Description

The action hides visible rows.

Action icon

Settings

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with ods/xlsx table.Robin.OpenSheetD oc
Yes
Starting row indexThe sequence number of the starting row in the range of rows to be hidden. The numbering starts from 1.Robin.Numeric
Yes
Ending row indexThe sequence number of the ending row in the range of rows to be hidden. The numbering starts from 1.Robin.Numeric
No

Special conditions of use

None.

Example of use

Task 

There is a tabular document. It is necessary to hide rows 2 and 3. 

Solution

Use the actions "Open", "Hide rows", "Save". 

Implementation

  1. Assemble a robot scheme consisting of actions:


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



  3. Set the parameters for the "Hide rows" action. 
    1. in the "Context" field specify the context of the opened document "Test 1";
    2. in the " Starting row index" field specify the index of the starting row in the range of rows that will be hidden;
    3. in the "Ending row index" field specify the index of the ending row in the range of rows to be hidden.


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


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

Result

The program robot completed successfully.

Lines 2 and 3 are hidden.