Row data Version 14 (Net)

Action group: Excel

Description

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

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Action context for working with an Excel document	Robin.Excel	Excel context	Yes
Row	Row 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 name	Name 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 index	The index of the column where the starting cell of the working range is located.	Robin.Numeric		No
Final column name	Name 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 index	The index of the column that contains the end cell of the working range.	Robin.Numeric		No
Skip hidden	Boolean variable. If the parameter value is True, then only visible cells are returned, otherwise - everything.	Robin.Boolean	true	No
Skip empty	Boolean variable. If the parameter value is True, then only filled cells are returned.	Robin.Boolean	true	No
Results
Result	The variable in which the values from the row will be written	Robin.Collection

The active context range is applied.

If you enter a string outside of this range, the action will return an empty result.

If you enter columns outside of this range, the action will trim the extra cells.

There is an Excel-document where you want to retrieve data from a certain row.

Use the "Open" "Row data", "Save" actions.

3. Set the "Row data" action parameters.

4. Set the "Save" action parameters.

5. Click "Start" in the top panel.

The row data from columns A to C was retrieved.