История страницы

Get table Version 14 (Net)

Action group: Excel

...

Description

Action returns cell values from the specified page area in the form of a table.

Icon

Parameters

Input parameters

Name	Description
Context	The action context for working with an Excel document
Start cell column name	The column name of the start cell (beginning of the range) from which the area will be set.
Start cell column index	The column index of the starting cell (range start) from which the area will be set.
Start cell row	The row of the starting cell (start of the range) from which the area will be set.
End cell column name	The column name of the end cell (end of range) to which the area to be copied will be set.
End cell column index	The column index of the end cell (end of range) to which the area to be copied will be set.
End cell row	The end cell row (end of range) to which the area to be copied will be set.
Skip hidden	Boolean variable.
Heading	If true, the first row of the table will be highlighted separately as a header and will not be included in the table content rows.
Remove duplicate header	If true, indexes will be added to the same column names in the header of the resulting table.

Output parameters

Result Variable to which the range data will be written

Settings

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	Context excel	Yes
Start cell column name	The column name of the initial cell (the beginning of the range) from which the area will be set. If the field is not filled in, the value from the "Index cell column name" field is taken.	String		No
Index cell column name	Column index of the initial cell (beginning of the range) from which the area will be set. If the field is not filled in, the boundary of the used area is taken.	Numeric		No
Start cell row	The row of the initial cell (beginning of the range) from which the area will be set. If the field is not filled in, the boundary of the used area is taken.	Numeric		No
End cell column name	The column name of the end cell (end of range) to which the area to be copied 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 area to be copied will be set. If the field is not filled in, the boundary of the used area is taken.	Numeric		No
End cell row	The row of the end cell (end of the range) to which the area to be copied will be set. If the field is not filled in, the boundary of the used area is taken.	Numeric		No
Skip hidden	A boolean variable. If True, only visible rows and columns are returned, otherwise all rows and columns are returned.	Boolean	true	No
Heading	If true, the first row of the table will be highlighted separately as a header and will not be included in the table content rows.	Boolean	true	No
Remove duplicate header	If the value is "true", indexes will be added to the same column names in the header of the resulting table. The numbering starts from 1.	Boolean	true	No
Results
Result	The variable into which the range data will be written	Table

Special conditions of use

For checkbox "Heading"

Parameter operation: If "true", the action will keep the first row of the source table in the header of the returned tabular value, i.e. it will not be the row with the table contents.

...

From excel we get the table:

Image RemovedImage Added

With this option enabled, the log will show "Columns: 3; Rows: 2" because the first row of the taken area has become a header with the column names "No.", "Title" and "Tests". These headings cannot be accessed as a row of data to read, but you can use the column names to access a specific cell or column (actions from the "Tables" group). If the option is off, the log will show "Columns: 3; rows: 3", the column names in the header will be "1", "2" and "3".

For the "Remove duplicate header" checkbox

When true, the header of the tabular value that actions return as a result will have indices added to the same column names. The numbering starts from 1.
Example #1:
There is a table in Excel:
Image RemovedImage Added
With "Remove duplicate header" = true, and "Heading" = True, the "Get table" action will return a table of 10 rows and 4 columns. The column names of this table will be "No.", "Title", "Tests1", "Tests2".
Example #2:
There is a table in excel:
Image RemovedImage Added
When "Remove duplicate header" = true, and "Heading" = True, the "Get table" action will return a table of 4 rows and 5 columns. The column names of this table will be:
"Test31", "Test21", "Test22", "Test32", "Test1".

...

For example, the source table has columns "Test1", "Test" and "Test". If we add indexes only to the current takes, the names will become "Test1", "Test1" and "Test2", i.e. eventually there will be new takes with the name "Test1". Therefore, when renaming a particular column, the action should check if another column already has such a name and if there is such a match, the current column should have the next index. That is, in this case the action will rename the columns as "Test1", "Test2" and "Test3".

Example of use

Task

There are 2 Excel documents "Test" and "Test1". It is necessary to take a table from the "Test" document and paste it into the "Test1" document starting from cell A3.

Image RemovedImage Added

Solution

Use the actions "Open", "Get table", "Insert table", "Save".

Implementation

Assemble a robot scheme consisting of the actions: "Open", "Get table", "Insert table", "Save".
Configure parameters for the "Open" action. In the "File path" field, specify the path to the required Excel file. Check the Visible = true checkbox to display robot actions on the screen.
Image RemovedImage Added
Set up parameters for the "Get table" action. In the "Context" field specify the context of the opened document, create a variable of the "Table" type to which the data will be written and specify it in the "Result" field. Leave the other fields empty, because it is necessary to take the table completely.
Image RemovedImage Added
Configure parameters for the "Open" action. In the "File path" field, specify the path to the required Excel file where the table should be inserted. Check the Visible = true checkbox to display robot actions on the screen.
Image RemovedImage Added
Customize parameters for the "Insert table" action. In the "Context" field specify the context of the opened document, in the "Start cell column name" field specify the value "A", in the "Start cell row" field specify the value "3". In the "Table" field specify the previously created variable "Table" with data.
Image RemovedImage Added
Customize parameters for the "Save" action. In the "Context" parameter specify the context of the Excel document where the table with data will be inserted.
Image RemovedImage Added
Launch the robot using the "Start" button in the top panel.