Create Version 2 (Python)

Action group: Office

Description

Action creates a new spreadsheet in the specified folder

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
Document nameThe name of the new document to create. This action creates a file with the extension from the file name (sould be ods or xlsx)Robin.String
Yes
FolderThe path to the folder where the document will be savedRobin.FolderPathC:\doc\imgYes
OverwriteBoolean variable, optional parameter. The default is false. If the value of the parameter is True and a file with the same name already exists in the folder, then the existing file will be overwritten.Robin.BooleantrueNo
Results
Path to fileFull path to the created file.Robin.FilePath

Special conditions of use

None.

Example of use

Task

Create a New.xlsx file on the desktop. 

Solution

Use the action "Create".

Implementation

  1. Move the "Create" action to the workspace and fill in its parameters
    In the "Document name" field specify the value = New.xlsx
    In the "Folder" field specify the future location of the document. 
    In the "Path to file" field, specify the "Path to file" variable, having created it in advance.


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

Result

The program robot completed successfully.

A document is created on the desktop. The path to the file is saved to a variable.