Choosing the Excel package in Enterprise A2019

Enterprise A2019 includes packages to support three types of Microsoft Excel usage. For optimal results, use the package that corresponds to the type of Excel that is available on the device you are running bots on.

• No Excel installed: If you do not have Microsoft Excel installed on the device on which you are running bots to automate Excel-related processes, use the Excel basic package.
• Desktop Excel installed: If you have a desktop version of Microsoft Excel installed on your computer, use the Excel advanced package in your bots.
• Online Office 365 Excel only: If you are using Microsoft Excel 365 on a web browser, use the Office 365 Excel package for automating tasks related to Excel.

Before you start

1. Use the Connect action to establish a connection to the Office 365 server.
   See Using the Connect action.

   Note: Office 365 packages do not currently support Multi-Factor Authentication or Single Sign-on.
2. Use the Open action to select a workbook, or the Create action to create a new workbook. See Workbook operations.
3. Optional: If the workbook contains more than one worksheet, use the Activate sheet action to specify which worksheet to use.
4. Use a combination of actions available in this package to automate tasks.
   Note: To use actions from other Office 365 packages, establish a connection using the Connect action from that package.
5. Use the Close action to exit from the workbook.
6. Use the Disconnect action to terminate the connection.

Actions in the Office 365 Excel package