Microsoft Excel is a common tool in automation projects. Hyland RPA Designer and its activities provide several ways to interact with Microsoft Excel.
| Activity | Description |
|---|---|
| Open Workbook | Excel scope activity that opens or creates a workbook. |
| Close Workbook | Closes a workbook. |
| Append Range | Writes a defined range, for example, from a data table to an Excel spreadsheet. |
| Clear Filter | Clears all filters in the spreadsheet or table. |
| Delete Column | Deletes a column in a spreadsheet or table. |
| Encrypt Workbook | Encrypts an Excel workbook. The password is then required as input. |
| Execute Macro | Executes an Excel macro. |
| Filter Table | Sets a filter on a spreadsheet or table. |
| Find Range | Searches for a value in the entire spreadsheet or within a specified range. |
| Get Cell Color | Gets the color of a cell and return it as a string. |
| Get Cell Formula | Gets the cell formula and returns it as a string. |
| Get Cell Value | Gets the value of a cell and return it as a string. |
| Insert Column | Inserts a column into a spreadsheet or table. |
| Read Range | Gets a range and stores all values in a DataTable. |
| Set Range Color | Colors a range with the selected color. |
| Sort Table | Sorts a spreadsheet or table. |
| Excel To CSV | Converts the workbook to a CSV file. |
| Write Range | Writes a DataTable to a spreadsheet. |
| Write Cell | Writes a text into a cell. |
Note: You can choose between two different Excel providers.
To use the Microsoft.Office.Interop.Excel assembly. you must have Microsoft Excel installed and OfficeInteropt selected as the Excel provider.
If you do not have MS Excel installed on your client, select ExcelFile as the provider. The provider only needs to be selected in the Open Workbook activity, so that it applies to all activities within that scope.
See the Hyland RPA Activities documentation for more information.