MS Excel

Microsoft Excel is a common tool in automation projects. AM Composer and its activities offer various ways to interact with Microsoft Excel.

Please note! You can choose between two different ExcelProviders. In order to use the Microsoft.Office.Interop.Excel assembly. you need to have MS Excel installed and choose as ExcelProvider OfficeInteropt. If you don´t have MS Excel installed on your client please choose ExcelFile as provider. The provider just needs to be choosen in the Open Workbook Activity, so it´s valid for all activities inside this scope.
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 e.g. 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 colour of a cell and return the colour 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 Colour a range with the chosen colour.
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.
Was this article helpful?
1 out of 1 found this helpful