Save Version 1 (Python)

Action group: ONLYOFFICE

Description

The action returns the context for working with the ONLYOFFICE tabular document.

The ONLYOFFICE application must be installed to work with the action.

The action opens the document in visible mode.

If the robot opens multiple documents, they will be opened in the way specified in the application settings. Open:

• tabs of a single application
• individual application instances

If a document in ods format is password-protected, then

• the action will not be able to process it, you need to get context to further process the document and enter the password using other actions
  
• the action will not terminate with an error 

Automatic closing of the document is not provided. To close a document, use the "Close" action of the "ONLYOFFICE" group, "Table Editor" subgroup.

You can familiarize yourself with the operation of the ONLYOFFICE Table Editor application in the User Manual.

Action icon

Settings of parameters

Special conditions of use

1. When running ONLYOFFICE actions, the document must be closed.

      2. File extensions that the action can open: .xlsx, .xls, ods.

      3. For correct start of actions when working with actions of ONLYOFFICE group of Windows OS it is necessary to add ONLYOFFICE plugin.

Example of use 

Task

There is a tabular document: "Book 1.xlsx". It is necessary to make changes in the opened file to save this document in ONLYOFFICE.

Solution

When running ONLYOFFICE actions, the document must be closed.

• In order to open the document you should set the "Open" action on the workspace 
• Correctly set the "File path" parameter - specify a file with an available extension
• Amend it
• Save file

Implementation

1. Open the ONLYOFFICE action group. 

2. Assemble a robot scheme consisting of actions:

Option 1

Task

Open a file in ONLYOFFICE.

Solution

Use "Open", "Safe", "Close" actions.

Implementation

1. Move the "Open" action to the Studio workspace, having previously placed the file to load in one of the folders on your computer.

2. Set the parameters of the "Open" action by specifying the path to the file.

3. Make manual changes to the file.

4. In order to close the file with changes, you need to use the "Save" and "Close" actions in sequence.

5. To do this, click the cursor on the "Save" action on the diagram and fill in the "Parameters" field for this action. and set the "Parameters" field for this action. 

6. Set the parameters for the "Close" action. You can see more details here: Close (ONLYOFFICE)

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

Result

The program robot completed successfully.