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.2 15 September 2025 With package update and Automation 360 v.38 (Sandbox) release 21.112 or later 11307 or later
6.23.1 15 July 2025 Package-only; post Automation 360 v.37 release 21.112 or later 11307 or later
6.23.0 4 June 2025

With Automation 360 v.37 (Sandbox) release (macOS-related support)

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

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
What's changed
Ignore errors related to sensitivity label (Service Cloud Case ID: 01990204)

When you deploy an automation on a device where the data classification pop-up to classify the sensitivity of the data is not enabled or the Excel version that is available on the device does not support sensitivity label, automation deployment will fail. Such disruptions need updates to individual automations with significant efforts to maintain consistency across all environments. By enabling the Continue on error check box, any version dependencies are handled without impacting the automation deployments.

Consider a scenario where you have a development environment that has the sensitivity label enabled in the available Microsoft Office version, and a User Acceptance Testing (UAT) environment where only some devices have sensitivity feature enabled in the corresponding Microsoft Office version. Prior to this update, if an automation that was created in the development environment and included a sensitivity label was deployed on the UAT environment, the deployment would fail on the devices where the sensitivity label was not enabled. However, the automation developer can now select the Continue on error check box in the production environment before deploying this automation to the UAT environment in order to ignore the sensitivity label error and complete the deployment.

The following actions in this package are now updated to include the Continue on error check box that enables you to ignore any errors caused due to sensitivity label:
Fix
After updating to this package version, the Enter formula for specific cell field in the Set cell formula action no longer adds @ to the cell formula. Previously, if you added a cell formula command such as =INDEX(A3:A4,B2), this would be changed to =@INDEX(A3:A4,B2) during automation deployment.

Service Cloud Case ID: 02227519

6.23.1

  • Compatible Bot Agent version: 21.112 or later
  • Compatible Control Room version: 11307 or later
Fix
When you use the For each row in worksheet iterator to loop through the specified cells in an Excel file worksheet, the iterator now retrieves the values correctly even if the name of that Excel file contains any special characters such as exclamation mark (!).

Service Cloud Case ID: 02205283
You can now use the Insert/Delete rows/columns action to remove the selected range of rows even when an Excel file worksheet contains a table header.

Service Cloud Case ID: 02196525
Limitation
When you use the bulk update option for updating Excel advanced package to this version (6.23.0), an extra character ($) is added to any variable that is used in the Convert Excel to PDF action, which is used to convert a workbook, worksheet, or a CSV file into a PDF file.

Service Cloud Case ID: 02212023

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.

Open | Create workbook

Automation development on macOS

Citizen developers and professional automation experts can now develop and run automations on macOS platforms on their devices. This package has been enhanced to support macOS, ensuring a uniform development and portability experience.
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
Limitation
When you use the bulk update option for updating Excel advanced package to this version (6.23.0), an extra character ($) is added to any variable that is used in the Convert Excel to PDF action, which is used to convert a workbook, worksheet, or a CSV file into a PDF file.

Service Cloud Case ID: 02212023

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