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

Automation 360 v.37 (Sandbox) 릴리스(macOS 관련 지원)

 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 packages에 Control Room 추가.

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

시민 개발자와 전문 자동화 전문가들은 이제 자신의 기기에서 macOS 플랫폼에서 자동화를 개발하고 실행할 수 있습니다. 이 package는 macOS를 지원하도록 향상되어, 일관된 개발 및 이식성 경험을 보장합니다.
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: 이 package 버전은 Automation 360 v.30 릴리스에서도 사용할 수 있습니다.
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