Hide rows (Office)

Hide rows Version 1 (Python)

Action group: Office

Description

The action hides visible rows.

Action icon

Settings

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.