Microsoft 365 Excel package - The Microsoft 365 Excel package provides a set of actions you can use to automate tasks in the online version of Microsoft Excel, directly through a web browser using Microsoft 365 . Use this package to build bots that read, write, format, and manage Excel workbooks, worksheets, cells, rows, columns, and tables.

Automation 360

The Microsoft 365 Excel package provides a set of actions you can use to automate tasks in the online version of Microsoft Excel, directly through a web browser using Microsoft 365. Use this package to build bots that read, write, format, and manage Excel workbooks, worksheets, cells, rows, columns, and tables.

When to use this package

Important: Microsoft has deprecated EWS API for Exchange Online and has recommended users to move to Graph API. Starting from Automation 360 v.29, Office 365 Excel package is now called Microsoft 365 Excel package. Although the package name has changed, the functionality remains the same. So your existing bots from previous releases will continue to work as expected after an update to Automation 360 v.29.

Automation 360 includes three packages for Microsoft Excel automation. Choose the package that matches your environment:

Your Excel environment Recommended package
No Microsoft Excel installed on the bot device Excel basic package
Desktop version of Microsoft Excel installed Excel advanced package
Microsoft Excel accessed via web browser (Microsoft 365) Microsoft 365 Excel package

Some of the use cases of Microsoft 365 Excel package are:

  • Read data from online Excel workbooks and write it to databases, other files, or applications
  • Automate report generation by creating and populating workbooks with data from other systems
  • Clean and format spreadsheet data, such as delete rows, insert columns, apply cell colors and formatting
  • Loop through rows in a data table to process records in bulk
  • Retrieve specific cell values, formulas, or ranges to drive downstream automation logic
  • Manage multiple worksheets, such as create, rename, hide, copy, and switch between sheets
  • Automate table operations such as creating, filtering, and retrieving table data
Note:
  • The Microsoft 365 Excel package works only with workbooks stored in OneDrive or a OneDrive-connected folder. The workbook file must be accessible from the OneDrive path you specify in the Open action.
  • All session names are case-sensitive. Use the same session name consistently across the Connect, Open, and all subsequent actions in your bot.
  • To use actions from other Microsoft 365 packages (such as Calendar or OneDrive) in the same bot, establish a separate connection using the Connect action from that package.
  • Worksheet names cannot exceed 31 characters and cannot contain the characters \ / ? * [ ].

Actions in the Microsoft 365 Excel package

You can use the actions in the Microsoft 365 Excel package to perform the following operations:

Operations Description
Connect Using Connect action in Microsoft 365 Excel package
Cell Cell operations in Microsoft 365 Excel
Row and column Column/Row operations in Microsoft 365 Excel
Table Table operations in Microsoft 365 Excel
Workbook Workbook operations in Microsoft 365 Excel
Worksheet Worksheet operations in Microsoft 365 Excel

Example workflow

Your bot needs to open a monthly sales workbook, read data from a specific worksheet, delete outdated rows, and save the result.

  1. Drag the Connect action.
  2. In the Session name field, enter ExcelSession1.
  3. Drag the Open action.
  4. In the File path field, enter OneDrive/Reports/SalesReport.xlsx.
  5. In the Session name field, enter ExcelSession1.
  6. Drag the Switch to sheet action.
  7. Select May2025 by name.
  8. Drag the Delete row or column action.
  9. Under Row Operations, select Delete row by and enter 51:55 to delete rows 51 through 55
  10. Drag the Get cell action.
  11. Enter B3 for Cell name under Specific cell
  12. Assign output to a String variable TotalSales
  13. Drag the Close action to exit the workbook.
  14. Drag the Disconnect action to end the session.

Result: The bot removes stale data from the worksheet and captures the summary value for use in the next step of the automation.