История страницы
...
This action retrieves values from the cell area.
Action icon
Settings of parameters
| Property | Description |
| Type |
Тип
Контекст
ID документа
Лист
Наименование рабочего листа.
По умолчанию первый лист документа.
Ячейка От
Адрес начальной ячейки, от которой будет браться область.
Заполнять в формате "ХY", где "Х" - это имя столбца, а "Y" - номер строки.
Ячейка До
Адрес конечной ячейки, до которой будет браться область.
Заполнять в формате "ХY", где "Х" - это имя столбца, а "Y" - номер строки.
Таблица
| Filling example | Mandatory field | |||
| Parameters | ||||
| Context | Indentifier of session for action | Robin.SpreadShee ts | SpreadSheets context | Yes |
| Document ID | Indentifier of document for action | Robin.String | Yes | |
| Sheet | Name of working sheet. By default, the first sheet of the document. | Robin.String | No | |
| From сell | Address of starting сell to get range in format «XY», where «X» - column name and «Y» - row index | Robin.String | Yes | |
| To cell | Address of last сell to get range in format «XY», where «X» - column name and «Y» - row index | Robin.String | Yes | |
| With header | If the value is «true», the first row of the table will be highlighted separately as a header and will not be included in the rows of the table. | Robin.Boolean | true | No |
| Remove header duplicates | 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. | Robin.Boolean | true | No |
| Results | ||||
| Table | DataTable with content of range. | Robin.DataTable | ||
Special conditions of use
The Google Sheets API has a limit of up to 60 read-requests per user per minute. To ensure that the action does not immediately generate an error when the limit on the number of requests is reached, the action includes a loop operation that will resend requests within a minute.
- If the request is completed in that time, the action will complete successfully.
- If the request cannot be sent in this time, the robot will terminate with an error.
For "With header" checkbox
Parameter is 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 header will use the default names - 1, 2, 3, etc.
Example
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 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 header duplicates" checkbox
When “true”"true", indexes will be added to identical column names in the header of the tabular value that the actions return as a result. The numbering starts from 1.
Example 1
...
There is a table:
If "Remove header duplicates" = true, and "With header" = True, the action "Get area form table" will return a table with 10 rows and 4 columns. The names of the columns in the table will be: "№No.", "Title", "Tests1", "Tests2".
Example 2:
If "Remove header duplicates" = true, and "With header" = True, the action "Get area form table" will return a table with 4 rows and 5 columns. The names of the columns in the table will be:
"Test31", "Test21", "Test22", "Test32", "Test1".
...
- Assemble a robot scheme with actions:
- Set the "Context Google tables" action parameters.
Fill in the "The file path" and "Application name" fields (more about filling in these fields in section INSTRUCTIONS FOR CONNECTING Instructions for setting up a connection to Google Sheets/Docs/Drive). - Set the "Get area from table" action parameters.
In the ID field specify the part of the table's link.
- Click "Start" in the top panel.
...
Обзор
Инструменты контента