Show range Version 4 (Net)

Action group:  Excel 

Description

Action shows hidden columns and rows in an Excel file within a specified range. 

Icon


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

Start cell column name

The column name of the start cell (the beginning of the range) from which the displayed range will be set. If the field is not filled in, the value from the " Start cell column index" field is taken.

String


No

Start cell column index

The column index of the start cell (range start) from which the displayed range will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

Starting row

The sequence number of the start row of the range to be displayed.

Numeric


Yes

End cell column name

The column name of the end cell (end of range) to which the displayed range will be set. If the field is not filled in, the value from the "End cell column index" field is taken.

String


No

End cell column index

The column index of the end cell (end of range) to which the displayed range will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

Final row

The sequence number of the end row of the range to be displayed.

Numeric


Yes

Special conditions of use

None.

Example of use

Task

There is an Excel document in which 2 columns C and D are hidden:

It is necessary to make them visible.

Solution

Use the actions "Open", "Show range", "Save". 

Implementation

  1. Build a robot scheme consisting of actions:  


  2. Configure parameters for the "Open" action. In the "Path to file" field, specify the path to the required Excel file. Check the Visible = true checkbox to display robot actions on the screen.


  3. Customize parameters for the "Show range" action. In the "Context" field specify the context of the opened document, fill in other fields according to the range C1-D7. 


  4. Customize parameters for the "Save" action. Specify the context of the Excel document in the "Context" parameter. 


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

Result

The program robot completed successfully.

The 2 previously hidden columns C and D are displayed.