Manage spreadsheets, worksheets, tables, and data through Excel online
Microsoft Excel integration allows you to programmatically manage spreadsheets and data through the Microsoft Graph API. You can search for Excel files, create and manage worksheets, update cell values, work with tables including adding, updating and deleting rows, and perform data operations like filtering and sorting. This integration is perfect for automated reporting, data processing workflows, spreadsheet management, and building data-driven applications that interact with Excel files stored in OneDrive for Business or SharePoint.
Required:
action
- The operation to perform with ExcelFind Excel files by name in your OneDrive
Parameters:
filename
(required) - Name or partial name of the Excel fileExample:
Response:
Get all worksheets in a workbook
Parameters:
workbook-id
(required) - The ID of the Excel workbookExample:
Response:
Add a new worksheet to a workbook
Parameters:
workbook-id
(required) - The ID of the Excel workbooksheet-name
(required) - Name for the new worksheetExample:
Response:
Update the value of a specific cell or range
Parameters:
workbook-id
(required) - The ID of the Excel workbookworksheet-id
(required) - The ID or name of the worksheetcell-range
(required) - Cell address (e.g., A1) or range (e.g., A1:B2)value
(required) - Value(s) to insertExample:
Response:
Create a new table in a worksheet
Parameters:
workbook-id
(required) - The ID of the Excel workbookworksheet-id
(required) - The ID or name of the worksheettable-range
(required) - Range for the table (e.g., A1:D10)has-headers
(optional) - Whether first row contains headers (default: true)Example:
Response:
Add a new row to an existing table
Parameters:
workbook-id
(required) - The ID of the Excel workbooktable-id
(required) - The ID of the tablerow-data
(required) - Array of values for the new rowExample:
Response:
Retrieve all data from a table
Parameters:
workbook-id
(required) - The ID of the Excel workbooktable-id
(required) - The ID of the tableExample:
Response:
Remove a worksheet from a workbook
Parameters:
workbook-id
(required) - The ID of the Excel workbookworksheet-id
(required) - The ID or name of the worksheet to deleteExample:
Response:
Only .xlsx files (Office Open XML format) are supported - .xls files cannot be used. Works with OneDrive for Business and SharePoint, but not OneDrive Consumer accounts. Both PinkConnect and Paragon proxies are supported with different endpoint structures. Worksheet IDs containing special characters must be URL encoded. When working with tables, always fetch the workbook ID first using the search function.