A group of actions: Excel
The action extracts values of the cells from the specified area of the page anf returns data as a table.
Action icon
Settings
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Start cell column name | The column name of the starting cell (start of the range) from which the region will be set. If the field is not filled, then the value from the «Start cell column index» field is taken. | Robin.String | No | |
| Start cell column index | The column index of the starting cell (start of the range) from which the region will be set. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
| Start cell row | Row of the starting cell (start of the range) from which the region will be set. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
| End cell column name | The column name of the ending cell (end of range) to which the region will be set. If the field is not filled, then the value from the «End cell column index» field is taken. | Robin.String | No | |
| End cell column index | The column index of the ending cell (end of range) to which the region will be set. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
| End cell row | Row of the ending cell (end of range) to which the region will be set. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
| Skip hidden | Boolean variable. If the parameter value is True, then only visible rows and columns are returned, otherwise - everything. | Robin.Boolean | true | 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 in which the range data will be written | Robin.DataTable | ||
Обзор
Инструменты контента