A group of actions: SpreadSheets


The action returns values from the specified range of cells

Action icon

Settings

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextIndentifier of session for actionRobin.SpreadShee tsSpreadSheets contextYes
Document IDIndentifier of document for actionRobin.String Yes
SheetName of working sheet. By default, the first sheet of the document.Robin.String No
From сellAddress of starting сell to get range in format «XY», where «X» - column name and «Y» - row indexRobin.String Yes
To cellAddress of last сell to get range in format «XY», where «X» - column name and «Y» - row indexRobin.String Yes
With headerIf 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.BooleantrueNo
Remove header duplicatesIf 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.BooleantrueNo
Results
TableDataTable with content of range.Robin.DataTable  
  • Нет меток