Open (Office)

Open Version 2 (Python)

Action group: Office

Description

The action returns the context for working with the ods/xlsx document. To close the document, use "Close" or "Save" actions.

Settings

Special conditions of use

None.

Example of use

Task

There is a file Book1.xlsx it is necessary to set the value in cell A3=test 4 and save the document. 

Solution

Use the "Open", "Set cell value", "Save" actions. 

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 "Set cell value" action to the workspace and set 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 = 3. 
   In the "Value" field specify the value = test 4. 
   
   
3. Move the "Save" action to the workspace and set its parameters
   Specify the context of the opened document in the "Context" field.
   
   
   
   
4. Click on the "Start" button in the top panel. 
   
   

Result

The program robot completed successfully. The required value is set in cell A3. The file is saved.