Get row data (Office)

Get row data Version 1 (Python)

Action group: Office

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 ods/xlsx document	Robin.OpenSheetD oc		Yes
Column	The ordinal number of the row from which the data will be retrieved. If you enter a string outside the working range, the action will return an empty result	Robin.Numeric		Yes
Start cell	Name of the column where the starting cell of the working range is located	Robin.String		No
End cell	Name of the column that contains the end cell of the working range	Robin.String		No
Skip empty cells	If the parameter value is True, then only filled cells are returned.	Robin.Boolean	true	No
Results
Result	Variable to which the values from the string will be written	Robin.Collection

None.

There is an Excel document in which you need to get data into the variable "collection" from a certain row No. 1.

Use the actions "Open", "Get row data", "Save".

2. Set the parameter for the "Open" action (specify the Path to file).

3. Set the parameters for the "Get data from string" action.

a) Parameter "Context". Set the relationship with the "Open" action.

b) Parameter "Column". Specify the string from which we get data - 1.

c) Parameter "Start cell". Specify the starting column - A

d) Parameter "End cell". Specify the end column - C

In the "Result" field, specify a variable of the "collection" type, where the data from the row will be written.

4. Set the parameter for the "Save" action.

5. Launch the robot using the "Start" button in the top panel.

The program robot completed successfully.

Received row data from column A through C.