Save as Version 1 (Python)

Action group: Office

Description

Action saves the document under a different name

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for ods/xlsx document

Robin.OpenSheetD oc


Yes

Folder

Path to the folder where the document will be saved. If the field remains empty, the file is saved in the same folder where the original file was opened. You can enter it manually or select the folder in the "Select folder" modal window using the "three dots" button.

Robin.FolderPath

C:\doc\img

No

File name

The name of the new document to be created. If this field is left empty, the file is saved with the same name that the document had when it was opened. The extension can be left blank. If the extension is specified, it must match the extension of the source file

Robin.String


No

Overwrite

Boolean variable, optional parameter. Defaults to false. If True and a file with this name already exists in the folder, the existing file will be overwritten.

Robin.Boolean

true

No

Results

Path to file

The full path to the saved file.

Robin.FilePath



Special conditions of use

None.

Example of use

Task

There is a file Book1.xlsx on the desktop, it is necessary to execute the formula A1+A2 (result in cell A3), save the document in the folder "example" and close the document. 

Solution

Use the actions "Open", "Apply formula to cell", "Save as", "Close".

Implementation

  1. Move the "Open" action to the workspace and fill in its parameters
    In the "Path to file" field specify the path to the file Book1.xlsx





  2. Move the "Apply formula to cell" 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 "Formula" field specify the value = A1+A2 (English). 

  3. Move the Save As action to the workspace and set its parameter.
    In the "Context" field, specify the context of the open document.
    In the "Folder" field specify the folder where the document will be saved. 

  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 formula is executed in cell A3.

The file is saved and closed.