Excel advanced package updates

Review the updates in released versions of the Excel advanced 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 advanced 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.19.1 17 January 2024 Package-only; post Automation 360 v.31 release 21.112 or later 11307 or later
6.17.0 6 December 2023 With Automation 360 v.31 (Sandbox) release 21.112 or later 11307 or later
6.16.4 17 July 2023 Package-only; post Automation 360 v.29 release 21.112 or later 11307 or later
6.15.1 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 advanced package, the naming convention is: bot-command-msexcel-<version.number>.jar

    For example, bot-command-msexcel-6.19.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
Fixes
You can now use the Open action in the Excel advanced package to open a Microsoft Excel file on Microsoft 365 OneDrive even when the file name contains characters in Japanese language.

Service Cloud Case ID: 02109981
When you use the Read option > Read cell value option from the Get worksheet as data table action of the Excel advanced package, the value from the specified cell of the worksheet is now retrieved correctly.

Service Cloud Case ID: 02090859

6.19.1

Note: This package is also available in the Automation 360 v.32 release.
  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
What's new
Save as action added to the package

The Excel advanced package now includes the Save as action that can be used to save a copy of your Microsoft Excel workbook in a specific location.

Save as action for workbook
Fixes
Bots that contain actions from the Excel advanced package now complete without any delay or latency.

Service Cloud Case ID: 01996572
The interval times to retrieve values from a single cell in a Microsoft Excel spreadsheet or a CSV file using the Get single cell action are reduced.

Service Cloud Case ID: 02093701
The various fields available in the Find action are now translated correctly to the Japanese language.

Service Cloud Case ID: 01952045

6.17.0

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
What's new
Updated actions in Excel advanced package ( Service Cloud Case ID: 01953992)
The names of the following actions in the Excel advanced package have been updated and now include the option to filter and sort data within specified worksheets:

6.16.4

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
Note: This package version is also available in the Automation 360 v.30 release.
Fixes
You can now use the Open action in the Excel advanced package to open a Microsoft Excel file on Sharepoint even when the file name contains characters in Japanese language.

Service Cloud Case ID: 01949384
The description of the Find action is now correctly translated in the Japanese language.

Service Cloud Case ID: 01952045
Fix
In the Excel advanced package, you can use the Match case or Match entire cell contents options within the Search options field of the Find action to search for a value in an Excel sheet, even when the specified sheet is in a protected or read-only mode.

Service Cloud Case ID: 01970516, 01973805, 01981779

6.15.1

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
Fix
You can now create an Excel workbook or .csv file using the Create workbook action in the Excel advanced package without any issues.

Service Cloud Case ID: 01945223