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.23.0 15 May 2025 Package-only; post Automation 360 v.36 release 21.112 or later 11307 or later
6.21.7 14 February 2025 Package-only; post Automation 360 v.35 release 21.112 or later 11307 or later
6.20.0 14 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.23.0

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
What's new
New actions added (Service Cloud Case ID: 01990204)
The Excel advanced package is now updated to include the following new actions:

Additionally, you can set sensitivity label when you create or open a Microsoft Excel workbook.

Using the Open action for Excel advanced | Create workbook action

Fixes
You can use the Open action to open a file from Sharepoint, even if the filename is in Japanese.

Service Cloud Case ID: 02195924

When you use the Append worksheet action in a loop several times (three or more), you can now add a worksheet from an existing workbook successfully without encountering any issues.

Service Cloud Case ID: 02192857

If the Sheet contains a header option is enabled in the Open action or if it is enabled when you switch to another worksheet by using the Switch to Sheet action, errors are no longer encountered even when you open a worksheet that contains a single column with numbers.

Service Cloud Case ID: 02198103

When you use the Write from data table action to write values from a data table into a worksheet, only the data from the specified cells is written into the worksheet. The column names are no longer included if the Contains header option in the Open action is selected.

Service Cloud Case ID: 02187308

6.21.7

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
Fixes
You can now use the Open action to open a .xlxs file from a network folder (such as UNC network), even when it contains a special character such as %20 in the filename.

Service Cloud Case ID: 02155370

In the Write from data table action, if the Retain cell data type check box is selected, the corresponding data type is now correctly retrieved and the numerical values are no longer stored as text.

Service Cloud Case ID: 02172295, 02178341, 02180440

Automation runtime issues are no longer caused by the Close action and the automation is deployed successfully.

Service Cloud Case ID: 02166841

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