Get data from column Version 1 (Python)

Action group: Office

Description

The action retrieves data from the column

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for ods/xlsx documentRobin.OpenSheetD oc
Yes
ColumnThe column to which the action will be appliedRobin.String
Yes
Start line numberThe ordinal number of the starting string of the range of returned values. Numbering starts from 1. Default value: index of the first line of the area usedRobin.Numeric
No
End line numberThe ordinal number of the end string of the range of returned values. Numbering starts from 1. Default value: index of the last line of the used areaRobin.Numeric
No
Skip empty cellsReturn values of filled cells onlyRobin.BooleantrueNo
Results
ResultCollection of values obtained from the specified columnRobin.Collection

Special conditions of use

None.

Example of use

Task 

There is a file Book1.xlsx, it is necessary to get data from column A, save and close the document. 

Solution

Use the actions "Open", "Get data from column", "Save", "Close"

Implementation

  1. Move the "Open" action to the workspace and set its parameters
    In the "Path to file" field specify the path to the file Book1.xlsx



  2. Move the "Get data from column" action to the workspace and set its parameters
    In the "Context" field, specify the context created in step 1.
    In the "Column" field specify the value = A.
    In the "Result" field, specify the variable "Collection", having created it in advance. 
  3. Move the "Save" action to the workspace and set its parameter.
    In the "Context" field specify the context of the opened document.
  4. Move the Close action to the workspace and set its parameter.


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

Result

The program robot completed successfully.

The values from column A are written to the variable "Collection".

The file is saved and closed.