Minimal scopes per action
Each Microsoft Excel connection also requests
openid, offline_access, and User.Read. These connection scopes apply in addition to the action scopes in the table.| Action | Description | Minimum scopes |
|---|---|---|
| Add sheet to workbook | Adds a worksheet to an existing Excel workbook. | Files.ReadWrite.All |
| Add table row | Adds a new row to the end of a table. | Files.ReadWrite.All |
| Clear range | Clears cell contents, formatting, or both from a range without deleting the cells. | Files.ReadWrite.All |
| Create chart | Creates a chart from data in a range. | Files.ReadWrite.All |
| Create table | Creates a new table from a cell range. Tables enable filtering, sorting, and structured references. | Files.ReadWrite.All |
| Delete column | Deletes a column from a worksheet, shifting remaining columns left. | Files.ReadWrite.All |
| Delete row | Deletes a row from a worksheet, shifting remaining rows up. | Files.ReadWrite.All |
| Delete table row | Deletes a specific row from a table given its row index. | Files.ReadWrite.All |
| Format cells | Applies formatting to cells including font styles, background colors, and borders. | Files.ReadWrite.All |
| Get all table columns | Retrieves all columns from a table. | Files.ReadWrite.All |
| Get item by name | Searches for Excel files by name or resolves a direct URL. Returns file ID, driveId, name, URL, and metadata for use with other Excel actions. | Files.ReadWrite.All |
| Get range | Retrieves data from a specified cell range in a worksheet. Use this to read data that is not in a table. | Files.ReadWrite.All |
| Get sheet by item id | Retrieves all worksheets of an Excel workbook. | Files.ReadWrite.All |
| Get single table row | Retrieves a specific row from a table given its row index. | Files.ReadWrite.All |
| Get table rows | Retrieves rows from a table with pagination support, including the table name. Use this to read data from Excel tables. | Files.ReadWrite.All |
| Get tables | Retrieves all tables from a worksheet, specified by item id and sheet id. | Files.ReadWrite.All |
| Get workbook summary | Retrieves a summary of an Excel workbook including all sheets, their data ranges, tables, and charts. | Files.ReadWrite.All |
| Insert column | Inserts a new empty column to the left or right of a specified column, shifting existing columns. | Files.ReadWrite.All |
| Insert formulas | Inserts Excel formulas into cells at a specified range. Use this to add calculations like =SUM(), =AVERAGE(), =IF(), etc. | Files.ReadWrite.All |
| Insert row | Inserts a new empty row above or below a specified row, shifting existing rows down. | Files.ReadWrite.All |
| Merge cells | Merges cells in a range into a single cell. | Files.ReadWrite.All |
| Resolve drive | Resolves drive metadata by ID or searches for drives by name. Returns standardized items for ID field resolution. | Files.ReadWrite.AllSites.Read.All |
| Resolve item | Resolves Excel file metadata by ID or searches for files by name. Returns standardized items for ID field resolution. | Files.ReadWrite.All |
| Resolve table | Resolves table metadata by ID or searches for tables by name. Requires driveId and itemId. | Files.ReadWrite.All |
| Resolve worksheet | Resolves worksheet metadata by ID or searches for worksheets by name. Requires driveId and itemId. | Files.ReadWrite.All |
| Set alignment | Sets text alignment for cells (horizontal and vertical). | Files.ReadWrite.All |
| Set number format | Sets the number format for cells (currency, percentage, date, etc.). | Files.ReadWrite.All |
| Sort range | Sorts data in a range by one or more columns. | Files.ReadWrite.All |
| Update cells | Updates cells in a worksheet at a specified range. | Files.ReadWrite.All |
| Update table row | Updates values in a specific row or range within an Excel table. | Files.ReadWrite.All |