“Excel 活动包”可帮助用户自动执行 Microsoft Excel 的各项功能。众所周知，各类企业中的众多员工都在频繁使用该应用程序。
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.
The UiPath.Excel.Activities pack is compatible with the following Microsoft Excel versions:
All the activities in the latter category have to be included in Excel Application Scope to work, apart from the CSV ones. Starting with version 2.10.4 of the Excel activities pack, these activities can also be included in the Use Excel File activity.
For large spreadsheets that span over a great number of rows and columns, we recommend using the activities grouped under the App Integration chapter.
The StudioX chapter includes activities found in the UiPath.Excel.Activities pack that are designed for use in StudioX projects. To find out more about working with Excel activities in StudioX, see Excel Automation in the StudioX guide. StudioX activities can also be used in the Studio profile by selecting the Show StudioX filter in the Activities panel.
“Excel 活动包”不支持 Microsoft Excel 95 专用的旧版 Excel 二进制文件格式 (
- When you use activities that read, copy, or append ranges, please note that if a cell contains formatting information, Excel considers that cell as containing data, even though it appears empty.
- 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.
Updated 18 days ago