Microsoft 365 Excel package updates

Review the updates in released versions of the Microsoft 365 Excel 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 Microsoft 365 Excel 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
2.19.0 27 September 2024 With Automation 360 v.34 (Sandbox) release 20.11 or later 8750 or later
2.17.2 17 June 2024 With Automation 360 v.33 (Sandbox) release 20.11 or later 8750 or later
2.16.1 17 January 2024 Package-only; post Automation 360 v.31 release 20.11 or later 8750 or later
2.15.0 6 December 2023 With Automation 360 v.31 (Sandbox) release 20.11 or later 8750 or later
2.13.3 6 September 2023 With Automation 360 v.30 (Sandbox) release 20.11 or later 8750 or later
2.13.2 17 July 2023 Package-only; post Automation 360 v.29 release 20.11 or later 8750 or later
2.12.1 6 June 2023 With Automation 360 v.29 (Sandbox) release 20.11 or later 8750 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 Microsoft 365 Excel package, the naming convention is: bot-command-oexcelonline-<version.number>.jar

    For example, bot-command-oexcelonline-2.15.0.jar

For detailed steps on downloading a package and manually adding it to the Control Room, see Add packages to the Control Room.

2.19.0

  • Compatible Bot Agent version: 20.11 or later
  • Compatible Control Room version: 8750 or later
What's new
New actions in Microsoft 365 Excel package
Microsoft 365 Excel package is now updated to include the following actions:

2.17.2

  • Compatible Bot Agent version: 20.11 or later
  • Compatible Control Room version: 8750 or later
What's new
Support for certificate-based authentication (Service Cloud Case ID: 01958320)

Microsoft 365 Excel package Is now updated to use the centrally managed OAuth 2.0 token that supports certificate-based authentication

OAuth support for Microsoft Entra using Private Key JWT
Fixes
In the Create workbook action of the Microsoft 365 Excel package, the workbook is now created at the specified location (including a SharePoint folder) and is no longer set to the root directory by default.
Fixed security vulnerability issues. For more information, click the release download link and view the Security & Compliance reports at A-People Downloads page (Login required).

2.16.1

Note: This package is also available in the Automation 360 v.32 release.
  • Compatible Bot Agent version: 20.11 or later
  • Compatible Control Room version: 8750 or later
Fix
Fixed the vulnerabilities reported in the security scan.

2.15.0

  • Compatible Bot Agent version: 20.11 or later
  • Compatible Control Room version: 8750 or later
What's new

Internal update in packages

Minor update to support API tasks.
Support for Control Room managed OAuth2 authentication

The Microsoft 365 Excel package is now enhanced to support a more secure OAuth2 authentication using the Control Room managed option in the Connect action. Using this option, you can now automate the Microsoft 365 Excel application in unattended mode while ensuring compliance with your organization's security standards.

2.13.3

  • Compatible Bot Agent version: 20.11 or later
  • Compatible Control Room version: 8750 or later
What's changed

Help Center for bot developers

  • Help Center: We have added an in-app help for bot developers to get contextual information about actions and packages when building automations.

    In-product user assistance

  • Added intuitive icons for actions in a package.

2.13.2

  • Compatible Bot Agent version: 20.11 or later
  • Compatible Control Room version: 8750 or later
Fix
The name of the Create sheet action is now displayed correctly in the Japanese language.

2.12.1

Note: Microsoft has rebranded Office 365 to Microsoft 365. See Microsoft is rebranding 'Office' to Microsoft 365.
  • Compatible Bot Agent version: 20.11 or later
  • Compatible Control Room version: 8750 or later
What's changed
The Office 365 Excel package is renamed to Microsoft 365 Excel package.

Microsoft 365 Excel package
Unauthenticated proxy is now supported.