Get table (Office)

Get table Version 2 (Python)

Action group: Office

Description

The action returns cell values from the specified area of the page as a table.

Action icon

Settings of parameters

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Context for working with a document	Robin.OpenTextDo c		Yes
Table number	The number of the table in the document. The order starts from 1. The default value is 1	Robin.Numeric		No
Heading	If the value is «true», the table header will be inserted into the document along with its rows.	Robin.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. Numbering starts from 1.	Robin.Boolean	true	No
Results
Result	Result table	Robin.DataTable

Special conditions of use

For the "With Header" parameter:

From excel we get the table:

With this parameter 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 headers cannot be accessed as a row of data to read, but you can use the column names to access a specific cell or column (by 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" option

When true, the header of the tabular value that the actions return as a result will have indices added to the same column names. The numbering starts with 1.
Example No.1:
There is a table in a file with the extension xlsx:

With "Remove duplicate header" = true, and "With Header" = True, the "Take Table" action will return a table of 10 rows and 4 columns. The column names of this table will be "No.", "Robot Name", "Tests1", "Tests2".

Example No.2:
There is a table in a file with the extension xlsx:

When "Remove duplicate header" = true, and "With Header" = True, the "Take 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’.

If false, the column names will remain the same. Actions on net that return/process such tables with duplicated column names will crash with an error, because net cannot have a header with the same column names.
For example, the source table has columns "Test1", "Test" and "Test". If we add indexes only to the current doubles, the names will become "Test1", "Test1" and "Test2", i.e. new doubles with the name "Test1" will appear. 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 is a file Book1.xlsx it is necessary to write values from row 1-4 of column A to the variable "Table", save and close the document.

Solution

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

Implementation

Assemble a robot scheme consisting of actions:
Set the parameter for the "Open" action.
In the "File path" field specify the path to the file Book1.xlsx
Customize parameters for the "Retrieve table" action.
In the "Context" field specify the context created in step 1
In the "Start cell row" field specify the value = 1.
In the "End cell row" field specify the value = 4.
In the "Start cell column" field specify the value = A.
In the "End Cell Column" field, specify the value =A.
Specify in the "Result" field a variable of the "Table" type created in advance.
Set the parameter for the "Save" action.
Specify the context of the opened document in the Context field.
Launch the robot using the "Start" button in the top panel.