Insert the table (Office)

Insert the table Version 1 (Python)

Action group: Office

Description

The action inserts the table into the document

Action icon

Settings

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	The context of the action for working with the ods/xlsx table.	Robin.OpenSheetD oc		Yes
Table	The table to be inserted.	Robin.DataTable		Yes
Name of the initial cell column	The name of the column of the initial cell in the document where the upper-left cell of the specified table will be inserted. If the field is not filled in, then the value is taken from the field «Index of the column of the initial cell».	Robin.String		No
Index of the initial cell column	The index of the column of the initial cell in the document where the upper-left cell of the specified table will be inserted. If the field is not filled in, then the border of the used area is taken.	Robin.Numeric		No
The row of the initial cell	The row of the cell in the document where the upper left cell of the specified table will be inserted.	Robin.Numeric		No
With the title	If the value is «true», the table header will be inserted into the document along with its rows.	Robin.Boolean	true	No

Special conditions of use

The action inserts a table into a tabular document.

To insert a table in a certain place of the document, the user should specify the row and column of the cell where the upper left cell of the specified table will be inserted.
If the user does not specify the row and column of the cell, the table will be inserted in the border of the used area of the document - in the upper left cell of the used area of the document.
To identify a column, the user can specify a column name or index.
If the column name is not filled in, the value from the column index parameter is taken.
If the column name is filled in, the column index is ignored.
If an invalid column name/index is specified, the action will generate an error. Error description: "An invalid column is specified.".
If an invalid row is specified, the action will generate an error. Error description: "An invalid row is specified.".
If a row is specified but no column is specified, the top left cell of the table will be inserted into the first column of the area used and the specified row.
If a column is specified but no row is specified, the top left cell of the table will be inserted into the first row of the area being used and the specified column.
The user can insert the table with or without a header. If with a header, both the header and rows of the specified table will be inserted into the document. If without a header, only the rows of the specified table will be inserted into the document.

Example of use

Task

There are 2 tabular documents "Test 1" and "Test 2". It is necessary to take the table from the document "Test 1" and insert it into the document "Test 2" starting from cell A3.

Solution

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

Implementation

Assemble a robot scheme consisting of actions:
Set parameters for the "Open" action. In the "File path" field specify the path to the required tabular document.
Set parameters for the " Take 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.
Set parameters for the "Open" action. In the "File path" field specify the path to the required tabular document where the table is to be inserted.
Set up parameters for the "Insert the table" action. In the "Context" field specify the context of the opened document, in the " Name of the initial cell column" field specify - A, in the "The row of the initial cell" field - 3. In the "Table" field specify the previously created variable "Table" with data.
Set parameters for the "Save" action. In the "Context" parameter specify the context of the tabular document in which the table with data will be inserted.
Launch the robot using the "Start" button in the top panel.