Show rows Version 1 (Python)

Action group: Office

Description

Action shows hidden rows

Action icon

Settings of parameters

Special conditions of use

None.

Example of use

Task

There is a tabular document in which rows 2 and 3 are hidden. It is required to make them visible.

Solution

Use the actions "Open", "Show rows", "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 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 to be displayed;
   3. in the "Ending row index" field specify the index of the end line in the range of lines to be displayed.
   4. 
      
      
4. Set the parameters of the "Save" action.
   
   1. 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 lines are displayed in the document.