Open 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.

      4. Realization of the full cycle of work with the table should contain all 4 actions of the Table Editor - "Open" - to start working with the file, "Run external macro". - to make changes, "Save" - to save changes and "Close" at the end of work with the file.   

      5. 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 a document, you must run the "Close" action. 

Example of use 

Task

There is a tabular document: "Book 1.xlsx". It is necessary to open this document in ONLYOFFICE.

Solution

When running ONLYOFFICE actions, the document must be closed.

In order to open the document you need to:

• Move the "Open" action ONLYOFFICE to the workspace 
• Correctly set the "File path" parameter - specify a file with an available extension.
• Start the robot

It should be noted that if you start 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 start the "Close" action. You can see more details here: Close (ONLYOFFICE)

Implementation

1. Open the ONLYOFFICE action group.   

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

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

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

Result

The program robot completed successfully.

The action opened a table file and returned a context for working with table actions ONLYOFFICE.