A group of actions: SpreadSheets
The action returns values from the specified range of cells
Settings
Property | Description | Type | 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 |
Обзор
Инструменты контента