Action group: Excel
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
| 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 | |
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.
There is an Excel document "Book1.xlsx".
It is necessary to open the file "Book1.xlsx" and delete Sheet2 in it.
Use the "Open" and "Delete sheet" actions.
The program robot completed successfully.
The document is opened and Sheet2 is deleted from the document. The changes are saved.
