The Excel activities package aids users to automate all aspects of Microsoft Excel, as we know it is an application intensely used by many in all types of businesses.
It contains activities that enable you to read information from a cell, columns, rows or ranges, write to other spreadsheets or workbooks, execute macros, and even extract formulas. You can also sort data, color code it or append additional information.
The activities grouped under the System chapter can be executed even if Microsoft Excel is not installed on the machine, whereas the ones under the App Integration chapter require the app on the machine on which they run.
All the activities in the latter category have to be included in Excel Application Scope to work, apart from the CSV ones.
Dedicated activities enable you to work with
.csv files, while all the others work with
.xls. The ones that only work with Excel Application Scope can also work with
The old Excel Binary File Format (
.XLS) specific to Microsoft Excel 95 is not supported by the Excel Activities Pack.
For large spreadsheets that span over a great number of rows and columns, we recommend using the activities grouped under the App Integration chapter.
Please note that the Microsoft Office 2016 version 1708 (Build 8431.2079) changes the window title of files that are being edited and saved from "FileName.xlsx - Excel" to "FileName.xlsx - Saved". After closing the file, the filename reverts to normal.
This may cause some problems if your automation project uses selectors which contain the window title. For example, the following selector no longer works if your Excel version is the previously mentioned one:
<wnd app='excel.exe' cls='XLMAIN' title='FileName.xlsx - Excel' /> <wnd cls='EXCEL7' title='FileName.xlsx' />. To prevent this issue, we recommend using a dynamic variable selector.