Microsoft 365 Excel
The Microsoft 365 Excel modules enable you to monitor workbooks and rows or retrieve, add, update, or delete worksheets, rows, and tables in your Microsoft 365 Excel account.
To get started with Microsoft 365 Excel app, create an account at office.com.
Refer to the Microsoft Graph REST API documentation for the list of available endpoints.
To connect to the Excel app:
- Optional: In the Connection name field, enter a name in the connection.
- Optional: Click Show advanced settings to enter your custom app client credentials and add additional scopes as needed.
- Click Save.
- If prompted, log in to your Microsoft account and confirm the access.
After connecting the app, you can perform the following actions:
Use Keyword Query Language (KQL) search syntax to build your search queries in Microsoft modules. For more information, see Microsoft Graph help.
- Watch Workbooks
- Search Workbooks
- Download a Workbook
- Watch Worksheet Rows
- List Worksheets
- List Worksheet Rows
- Add a Worksheet
- Add a Worksheet Row
- Update a Worksheet Row
- Delete a Worksheet Row
- Watch Table Rows
- List Tables
- List Table Rows
- Get a Table
- Add a Table
- Add a Table Row
- Add a Table Column
- Update a Table
- Update a Table Column
- Delete a Table
When using these modules in the Microsoft 365 Excel integration, there is a maximum limit of 3300 records per request. This limit is set to prevent service interruptions and ensure optimal performance during data retrieval operations.
- Retrieve Data
- Make an API Call
The table here refers to the embedded table element in the Workbook. Not the entire table (workbook/worksheet).
Adds a new table.
Required Permissions: Files.ReadWrite, Files.Read.All, offline_access, User.Read
Connection | |
|---|---|
Update a Table | Select the option to choose the |
Workbook ID | Enter the Workbook ID to whose worksheet you want to add a table. |
Workbook | Select or map the workbook you want to use. |
Worksheet | Select the Excel sheet you want to add a table to. |
Has Headers | If you select this checkbox, the first defined row will be used as the table headers.  |
Address | Set the size of the table. For example, A1:C10 will create a table with 3 columns and 10 rows. |
- Add a Table Files: offline_access, User.Read, ReadWrite, Files.Read.All
- Add a Table Column: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Add a Table Row: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Add a Worksheet: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Add a Worksheet Row: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Delete a Table: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Delete a Worksheet Row: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Download a Workbook: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Get a Table: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- List Table Rows: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- List Tables: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- List Worksheet Rows: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- List Worksheets: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Retrieve Data: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Search Workbooks: offline_access, User.Read, Files.Read.All
- Update a Table: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Update a Table: Column: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Update a Worksheet Row: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Watch Table Rows: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Watch Workbooks: offline_access, User.Read, Files.Read.All
- Watch Worksheet Rows: offline_access, User.Read, Files.ReadWrite, Files.Read.All
- Make an API Call: offline_access, User.Read