订阅

UiPath 活动

UiPath 活动指南

关于“Excel 活动包”

“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.

📘

Important!

The UiPath.Excel.Activities pack is compatible with the following Microsoft Excel versions:
2010
2013
2016
Office 365

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.

专用活动支持使用“.csv”文件,而其余所有活动则适用于“.xlsx”和“.xls”文件。仅适用于“Excel 应用程序作用域”的活动同样支持使用“.xlsm”文件。

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.

Troubleshooting and Limitations

📘

重要提示:

“Excel 活动包”不支持 Microsoft Excel 95 专用的旧版 Excel 二进制文件格式 (.XLS)。

  • 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


关于“Excel 活动包”


建议的编辑仅限用于 API 参考页面

You can only suggest edits to Markdown body content, but not to the API spec.