Get value from cell Version 1 (Python)

Action group: Office

Description

The action returns the value from the specified cell

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for ods/xlsx documentRobin.OpenSheetD oc
Yes
Column of the cellColumn of the cell from which the action will return.Robin.String
Yes
Row of the cellRow of the cell from which the action will return.Robin.Numeric
Yes
Results
ResultThe variable into which the value from the cell will be writtenRobin.Object

Special conditions of use

None.

Example of use

Task 

There is a file Book1.xlsx, I need to get data from cell A4, save and close the document. 

Solution

Use the actions "Open", "Get value from cell", "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 value from cell" action to the workspace and fill in its parameters
    In the "Context" field, specify the context created in step 1.
    In the "Column of the cell" field specify the value = A.
    In the "Row of the cell" field specify the value = 4. 
    In the "Result" field specify the variable "Object", 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 value from cell A4 has been successfully written to the variable "Object". 

The file is saved and closed. 

  • Нет меток