Close Version 1 (Python)

Action group: ONLYOFFICE

Description

The action closes the context for working with a tabular document via ONLYOFFICE.

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

All documents opened by this robot that have not been closed by the Close" action before the robot ends will be closed automatically.

Regardless of how ONLYOFFICE is configured to open new documents in tabs or in individual instances of the application, when closed, the action closes all instances of the application with all tabs, even if not all of them were opened by the current robot.

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.

      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" opened in ONLYOFFICE. It is necessary to close this document in ONLYOFFICE.

Solution

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

2. In order to check the functionality of the "Close" action, the file must first be opened in the ONLYOFFICE Table Editor.

3. In order to open a document, you must set the Open (ONLYOFFICE) action parameters.

4. In order to close the document without changes it is necessary to set the "Close" action parameters ONLYOFFICE.

5. Start the robot

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, it is necessary to run the "Close" action. 

6. The "Close" action works the same way both when viewing a file (Open-Close) and when making changes to the file.

If you want to make changes to an open file, you must first run the "External macro" action (Run external macro (ONLYOFFICE)) or make changes manually, make changes to the file, run the Save (ONLYOFFICE) action and only then close the file.

Therefore, the implementation of a full cycle of work with a table should contain all 4 actions of the Table Editor - Open (ONLYOFFICE), Run external macro (ONLYOFFICE) - to make changes, Save (ONLYOFFICE) - to save changes and "Close" when work with the file is finished.

Implementation

1. Open the ONLYOFFICE action group.   

2. Assemble a robot scheme consisting of actions:

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

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

5. Move the "Close" action to the Studio workspace and set its parameters.

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

Result

The program robot completed successfully.

The action opened and closed the table file.

  • Нет меток