Open Version 11 (Net)
Action group: Excel
Description
The action returns the context for working with an Excel document. There is no automatic closing of the document. To close a document, use the "Close" action
Action icon
Settings of parameters
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| PathToFile | The path to the file to be opened. | Robin.FilePath | Yes | |
| Related context | The context for opening an already open Excel file for a new file in the same instance of the MS Excel application. Helps original data sources to display correctly when copied from one file to another. | Robin.Excel | Excel context | No |
| Open Visible | If the value is «true», the MS Excel application opens in visible mode and the work of the robot is visible. If «false», the application opens in the background and the work of the robot is not visible. When using a linked context, the value with which the linked Excel file was opened is applied. | Robin.Boolean | true | No |
| Password | Password from the Excel document. The default is no password. | Robin.Password | No | |
| Save changes | If the value is «true», any action to edit the document will immediately save the changes made. | Robin.Boolean | true | No |
| Results | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | |
Special conditions of use
Automatic closing of the document is not provided. It is necessary to use "Close" action.
Opening .txt files in UTF-8 encoding is possible through already opened Excel: Data -> From Text/CSV.
Example of use
Task
There is an Excel document "Book1.xlsx".
It is necessary to open the file "Book1.xlsx" and delete Sheet2 in it.
Solution
Use the "Open" and "Delete sheet" actions.
Implementation
- Assemble a robot scheme consisting of actions:
- Set the parameters of the "Open" action.
- Set the parameters of the "Delete sheet" action.
- Launch the robot using the "Start" button in the top panel.
Result
The program robot completed successfully.
The document is opened and Sheet2 is deleted from the document. The changes are saved.
Обзор
Инструменты контента