Save Version 18 (Net)

Action group: Excel 

Description

Saves an Excel document.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
FolderThe path to the folder where the document will be saved. If the field is left blank, then the file is saved in the same folder in which the original file was opened. You can enter it manually, or select a folder in the «Select folder» modal window using the «three dots» button.Robin.FolderPathC:\doc\imgNo
File nameThe name of the new document to be created. If this field is left blank, then the file is saved with the same name that the document had when it was opened.Robin.String
No
FormatFormat of document to save. If this field is empty, the file will be saved in the format the document had when it was opened.Robin.String
No
Results
Path to fileFull path to the saved file.Robin.FilePath

Special conditions of use

None. 

Example of use

Task

There is an Excel document "Test.xlsx".

You should save the file in its original format after making changes to the page (e.g., applying a filter).

Solution

  1. For any actions with a specific Excel document, you should first open the document, create its unique identifier (Context), so that further actions can be applied to a specific document. Open the document "Test.xlsx".
  2. Set filters.
  3. Save the Excel document.

Implementation

  1. Specify the parameters of the "Open" action. 
  2. Set the parameters of the "Apply auto-filter" action.
  3. Set the parameters of the "Save" action. 
  4. Launch the robot using the "Start" button in the top panel.

Result

The robot completed without errors. The file contains a table with filtered records.

  • Нет меток