Excel 基本版 软件包 updates

Review the updates in released versions of the Excel 基本版 软件包 such as new and enhanced features as well as fixes and limitations. The page also lists the release dates of each version, and the compatible Control Room and Bot Agent versions.

Versions summary

The following table lists the versions of Excel 基本版 软件包 released either with an Automation 360 release or as a package-only release (in descending order of release dates). Click the version link for information about updates in that 软件包 version.
Version Release date Release type Bot Agent version Control Room build
6.23.8 2025 年 12 月 15 日 Package-only; post Automation 360 v.39 (Sandbox) release 21.112 or later 11307 or later
6.23.0 2025 年 6 月 4 日

随着 Automation 360 v.37（沙盒）版本的发行（与 MacOS 相关的支持）

 21.112 or later 11307 or later
6.20.0 2024 年 6 月 17 日 With Automation 360 v.33 (Sandbox) release 21.112 or later 11307 or later
6.18.1 2023 年 10 月 20 日 Package-only; post Automation 360 v.30 release 21.112 or later 11307 or later
6.15.0 2023 年 6 月 6 日 With Automation 360 v.29 (Sandbox) release 21.112 or later 11307 or later
Note:
  • To download an individual 软件包 (updated in an Automation 360 release where you want only the 软件包), use this URL:

    https://aai-artifacts.my.automationanywhere.digital/packages/<package-file-name>-<version.number>.jar

  • For Excel 基本版 软件包, the naming convention is: bot-command-poi-<version.number>.jar

    For example, bot-command-poi-6.18.1.jar

For detailed steps on downloading a 软件包 and manually adding it to the Control Room, see 将 软件包 添加到 Control Room.

6.23.8

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
Fix

The Excel 基本版 软件包 now properly handles edit operations such as Set cell and Get cell on password-protected excel files when ypu provide valid credentials. This fix restores expected behavior and removes a key limitation for users who automate workflows involving secured excel documents.

Previously, the Excel 基本版 软件包 did not allow editing (Set cell, Get cell) of a password-protected excel file even when you provided correct credentials.

6.23.0

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
What's new

平民开发者和专业自动化专家现在可以在他们的设备上开发和运行 MacOS 平台上的自动化。 此 软件包 已增强，以支持 MacOS，确保统一的开发和可移植性体验。
What's changed
Updates to the user interface

We have enhanced the help text for the File path field within the Open action. This improves user experience by providing clearer instructions on path compatibility across different operating systems.
Fix
If you have used the Set cell 操作 to set the value to a cell that is part of the formula evaluation, the value is now obtained correctly even when that 操作 is within a loop.

Service Cloud Case ID: 02193616

6.20.0

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
Enhancement
The maximum size of the data that is allowed in an Excel file is now increased from 100,000,000 to 2,147,483,647. This enables users to now include a larger Excel file while using the Excel 基本版 软件包 to automate repetitive tasks in XLSX workbooks.

Service Cloud Case ID: 02103587, 02117904

6.18.1

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
Fix
If you use the Get single cell or Get multiple cell 操作 to retrieve data from a Microsoft Excel sheet, any data that is in the date type format within the specific cells is now extracted in the dd/mm/yyyy format.

Service Cloud Case ID: 01990340, 02183449

6.15.0

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
Fixes
You can use the Get cell address 操作 in the Excel basic 软件包 to read data from a specified cell in an Excel sheet, even when that cell contains advanced Excel function or formula (such as AVERAGEIFS,COUNTIF).

Service Cloud Case ID: 01791154
The Get multiple cells 操作 now displays the correct field name for selecting the range of cells.