A group of actions: Excel


The action returns all values in the working range of the specified page.

Action icon

Settings

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
RowRow index from which the data will be received. If you enter a string outside the working range, the action will return an empty result.Robin.Numeric Yes
Starting column nameName of the column where the starting cell of the working range is located. If the field is not filled, then the value from the «Starting column index» field is taken.Robin.String No
Starting column indexThe index of the column where the starting cell of the working range is located.Robin.Numeric No
Final column nameName of the column that contains the end cell of the working range. If the field is not filled, then the value from the «Final column index» field is taken.Robin.String No
Final column indexThe index of the column that contains the end cell of the working range.Robin.Numeric No
Skip hiddenBoolean variable. If the parameter value is True, then only visible cells are returned, otherwise - everything.Robin.BooleantrueNo
Skip emptyBoolean variable. If the parameter value is True, then only filled cells are returned.Robin.BooleantrueNo
Results
ResultThe variable in which the values from the row will be writtenRobin.Collection  
  • Нет меток