Microsoft Excel is a common tool in automation projects. Hyland RPA Designer and its activities offer various ways to interact with Microsoft Excel.
Activity | Description |
---|---|
Open workbook | Excel scope activity, that open's or creates a workbook. |
Close workbook | Close a workbook. |
Append range | Write a defined range for example, from a Data Table into an Excel sheet. |
Clear filter | Clear all filters inside the sheet or table. |
Delete column | Delete a column in a sheet or table. |
Encrypt workbook | Encrypt an Excel workbook. The password is then required as an input. |
Execute macro | Execute an Excel macro. |
Filter table | Set a filter on a sheet or table. |
Find range | Search for a value throughout the sheet or within a defined range. |
Get cell color | Readout the color of a cell and return the color as a String. |
Get cell formula | Readout the cell formula and return it as a String. |
Get cell value | Readout the value of a cell and return it as a String. |
Insert column | Insert a column into a sheet or table. |
Read range | Readout a range and store all values in a DataTable. |
Set range color | Color a range with the chosen Color. |
Sort table | Sort a sheet or table. |
To CSV | Convert the workbook into a CSV file |
Write range | Write a DataTable into a sheet. |
Write cell | Write a text into a cell. |
Note: You can choose between two different Excel providers.
To use the Microsoft.Office.Interop.Excel assembly. you need
to have MS Excel installed and OfficeInteropt selected as
Excel provider. If you don´t have MS Excel installed on your client select
ExcelFile as provider. The provider just needs to be
chosen in the Open Workbook Activity, so it´s valid for all
activities inside this scope.