Close Version 1 (Python)

Action group: Office

Description

Action closes the ods/xlsx document and releases the context

Action icon

Settings of parameters

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 , save and close the document. 

Solution

Use the actions "Open", "Set cell value", "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 "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 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 required value is set in cell A3. The file is saved and closed.