Excel basic package updates

Review the updates in released versions of the Excel basic package 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 basic package 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 package version.
Version Release date Release type Bot Agent version Control Room build
6.20.0 17 June 2024 With Automation 360 v.33 (Sandbox) release 21.112 or later 11307 or later
6.18.1 20 October 2023 Package-only; post Automation 360 v.30 release 21.112 or later 11307 or later
6.15.0 6 June 2023 With Automation 360 v.29 (Sandbox) release 21.112 or later 11307 or later
Note:
  • To download an individual package (updated in an Automation 360 release where you want only the package), use this URL:

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

  • For Excel basic package, 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 package and manually adding it to the Control Room, see Add packages to the Control Room.

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 basic package 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
When you use the Get single cell or Get multiple cell actions to retrieve data from a Microsoft Excel sheet, the date is now extracted in the same format that was used in that Excel sheet.

Service Cloud Case ID: 01990340

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 action in the Excel basic package 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 action now displays the correct field name for selecting the range of cells.