Просмотреть исходный

Get table Version 10 (Net)

Action group: Word

Description

The action saves the table from the document in the Table type variable.

Action icon

Settings of parameters

Parameter	Description
Context	The unique session identifier of the session to which the action will be applied.
Table number	Serial number of the table in the document.
Heading	If the value is "true", the table header will be inserted into the document along with its rows.
Remove duplicate header	If the value is "true", indexes will be added to the same column names in the header of the resulting table.

Output parameters

Result - result table.

Settings

Property	Description	Type	Filling example	Mandatory field
Parameters
Word-document	An instance of the Word document.	Robin.Word	Word context	Yes
Table number	Serial number of the table in the document. Order starts at 1. Default 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 "Heading" checkbox:

Parameter in action: if true, the action will save the first row of the source table into the header of the returned table value, i.e. it will not be a row with the table contents.
If "false", the first row will leave the table content part and the heading will use the default names - 1, 2, 3, etc.

Example:

Get the spreadsheet:
Документация ROBIN > Get table Word > image2022-9-22_15-37-2.png

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 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 "Remove duplicate header" checkbox:

If "true", the heading of the table value that the actions return as a result will have indexes added to the same column names. The numbering starts from 1.
Example No.1:
You have a table:

With "Remove duplicate header" = true, and "Heading" = 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:
You have a table:

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".

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

Save the table from the Word-document to a Table type variable.

Документация ROBIN > Get table Word > 24.jpg

Solution

Use the "Open document", "Get table", "Close document" actions.

Implementation

Assemble a robot scheme with the "Word" action group actions.
Set the "Open document" action parameters.
Set the "Get table" action parameters.
Set the "Close document" action parameter.
Start the robot by clicking "Start" in the top panel.

Result

The program robot completed successfully. The table was obtained.