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 "Row". 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.
