A group of actions: None
The action extracts values of the cells from the specified area of the page anf returns data as a table
Settings
Property | Description | Type | Filling example | Mandatory field |
Parameters | ||||
Context | Action context for ods/xlsx document | Robin.OpenSheetD oc | Yes | |
Start cell row | The string of the starting cell (beginning of the range) from which the area will be set. If the field is empty, then the border of the used area is taken. | Robin.Numeric | No | |
End cell row | The string of the end cell (end of the range) to which the copied area will be set. If the field is empty, then the border of the used area is taken | Robin.Numeric | No | |
Start cell column | The column of the starting cell (beginning of the range) from which the area will be set. If the field is empty, then the border of the used area is taken | Robin.String | No | |
Destination cell column | The column of the end cell (end of the range) to which the copied area will be set. If the field is empty, then the border of the used area is taken | Robin.String | 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 | The variable to which the range data will be written | Robin.DataTable |
Обзор
Инструменты контента