Skip to main content

​
What can you do with it?

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.

​
How to use it?

​
Basic Command Structure

/your-Microsoft-Excel-connection [action] [required-parameters] [optional-parameters]

​
Parameters

Required:
  • action - The operation to perform with Excel

​
Tools

​
Search Excel Files

Find Excel files by name in your OneDrive Parameters:
  • filename (required) - Name or partial name of the Excel file
Example: 
/your-Microsoft-Excel-connection
action: search-file
filename: Sales Report
Response: 
{
  "value": [
    {
      "name": "Sales Report 2024.xlsx",
      "id": "01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR",
      "lastModified": "2025-02-05T00:43:08Z",
      "webUrl": "https://onedrive.live.com/...",
      "workbookId": "01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR"
    }
  ]
}

​
List Worksheets

Get all worksheets in a workbook Parameters:
  • workbook-id (required) - The ID of the Excel workbook
Example: 
/your-Microsoft-Excel-connection
action: list-worksheets
workbook-id: 01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR
Response: 
{
  "value": [
    {
      "id": "{00000000-0001-0000-0000-000000000000}",
      "name": "Sheet1",
      "position": 0,
      "visibility": "Visible"
    },
    {
      "id": "{00000000-0002-0000-0000-000000000000}",
      "name": "Summary",
      "position": 1
    }
  ]
}

​
Create Worksheet

Add a new worksheet to a workbook Parameters:
  • workbook-id (required) - The ID of the Excel workbook
  • sheet-name (required) - Name for the new worksheet
Example: 
/your-Microsoft-Excel-connection
action: create-worksheet
workbook-id: 01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR
sheet-name: Q1 Data
Response: 
{
  "id": "{75A18F35-34AA-4F44-97CC-FDC3C05D9F40}",
  "name": "Q1 Data",
  "position": 2,
  "visibility": "Visible"
}

​
Update Cell Value

Update the value of a specific cell or range Parameters:
  • workbook-id (required) - The ID of the Excel workbook
  • worksheet-id (required) - The ID or name of the worksheet
  • cell-range (required) - Cell address (e.g., A1) or range (e.g., A1:B2)
  • value (required) - Value(s) to insert
Example: 
/your-Microsoft-Excel-connection
action: update-cell
workbook-id: 01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR
worksheet-id: Sheet1
cell-range: A1
value: Total Sales
Response: 
{
  "status": "success",
  "range": "A1",
  "values": [["Total Sales"]]
}

​
Create Table

Create a new table in a worksheet Parameters:
  • workbook-id (required) - The ID of the Excel workbook
  • worksheet-id (required) - The ID or name of the worksheet
  • table-range (required) - Range for the table (e.g., A1:D10)
  • has-headers (optional) - Whether first row contains headers (default: true)
Example: 
/your-Microsoft-Excel-connection
action: create-table
workbook-id: 01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR
worksheet-id: Sheet1
table-range: A1:D10
has-headers: true
Response: 
{
  "id": "Table1",
  "name": "Table1",
  "showHeaders": true,
  "showTotals": false,
  "style": "TableStyleMedium2"
}

​
Add Table Row

Add a new row to an existing table Parameters:
  • workbook-id (required) - The ID of the Excel workbook
  • table-id (required) - The ID of the table
  • row-data (required) - Array of values for the new row
Example: 
/your-Microsoft-Excel-connection
action: add-table-row
workbook-id: 01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR
table-id: Table1
row-data: ["Product A", 100, 25.99, 2599.00]
Response: 
{
  "index": 10,
  "values": [["Product A", 100, 25.99, 2599.00]]
}

​
Get Table Data

Retrieve all data from a table Parameters:
  • workbook-id (required) - The ID of the Excel workbook
  • table-id (required) - The ID of the table
Example: 
/your-Microsoft-Excel-connection
action: get-table-data
workbook-id: 01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR
table-id: Table1
Response: 
{
  "value": [
    {
      "index": 0,
      "values": [["Product A", 100, 25.99, 2599.00]]
    },
    {
      "index": 1,
      "values": [["Product B", 50, 35.99, 1799.50]]
    }
  ]
}

​
Delete Worksheet

Remove a worksheet from a workbook Parameters:
  • workbook-id (required) - The ID of the Excel workbook
  • worksheet-id (required) - The ID or name of the worksheet to delete
Example: 
/your-Microsoft-Excel-connection
action: delete-worksheet
workbook-id: 01HRDJMGPNAGXLOFE4URDYNKMBXOIES4BR
worksheet-id: Old Data
Response: 
{
  "status": "deleted",
  "message": "Worksheet 'Old Data' successfully deleted"
}

​
Notes

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.
⌘I