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


Property

Mandatory field

Description

Type

Parameters

Context
Context for working with a tabular document via ONLYOFFICE.

Robin.OnlyofficeCell

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

It should be noted that if you run the "Open" action and just view the document without making any changes to it, the document itself will not automatically close and will remain open. In order to close the document "as it is", you need to run the "Close" action. You can see more details here:

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.

  • Нет меток