Sign up
All data sources

Excel

OAuthexcel

Microsoft Excel connector for workbook automation via Microsoft Graph. CRITICAL USAGE RULES: 1. Provide itemId (drive item ID for the workbook) for all calls. 2. Use siteId when working with SharePoint-hosted workbooks. 3. For long-running workflows, create a session and pass workbook-session-id on subsequent calls. 4. Range addresses should use Excel A1 notation (e.g., Sheet1!A1:B10).

Get this contract as JSONConnect this source →

Provenance

PublisherExcel
API basehttps://graph.microsoft.com/

Freshness & coverage

FreshnessFreshness not declared
GeographicNot declared
TemporalNot declared
AuthenticationCredentials required (OAuth)

Methods (54)

  • excel_call_function

    unknown

    Execute an Excel workbook function with supplied parameters.

    Entitiesworkbook
    Input schema
    {
  "type": "object",
  "properties": {
    "functionName": {
      "type": "string"
    },
    "parameters": {
      "type": "object",
      "properties": {},
      "additionalProperties": true
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "functionName",
    "itemId"
  ]
}

  • excel_unmerge_range

    unknown

    Unmerge cells in a specified Excel worksheet range.

    Entitiesrange
    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "address": {
      "type": "string"
    },
    "shift": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "Up"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Down"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Left"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Right"
          ]
        }
      ]
    },
    "applyTo": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "All"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Formats"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Contents"
          ]
        }
      ]
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "address",
    "itemId"
  ]
}

  • excel_convert_table_to_range

    unknown

    Convert an Excel table into a worksheet range.

    Entitiestable, range
    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "itemId"
  ]
}

  • excel_protect_workbook

    unknown

    Protect an Excel workbook using specified protection options.

    Entitiesworkbook
    Input schema
    {
  "type": "object",
  "properties": {
    "options": {
      "type": "object",
      "properties": {},
      "additionalProperties": true
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_unprotect_workbook

    unknown

    Remove protection from an Excel workbook using specified options.

    Entitiesworkbook
    Input schema
    {
  "type": "object",
  "properties": {
    "options": {
      "type": "object",
      "properties": {},
      "additionalProperties": true
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_protect_worksheet

    unknown

    Protect an Excel worksheet using specified protection options.

    Entitiesworksheet
    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "options": {
      "type": "object",
      "properties": {},
      "additionalProperties": true
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "itemId"
  ]
}

  • excel_unprotect_worksheet

    unknown

    Remove protection from an Excel worksheet using specified options.

    Entitiesworksheet
    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "options": {
      "type": "object",
      "properties": {},
      "additionalProperties": true
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "itemId"
  ]
}

  • excel_list_tables

    read

    List tables in an Excel workbook.

    Input schema
    {
  "type": "object",
  "properties": {
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_add_table

    write

    Create an Excel table from a worksheet range.

    Input schema
    {
  "type": "object",
  "properties": {
    "address": {
      "type": "string"
    },
    "hasHeaders": {
      "type": "boolean"
    },
    "worksheetId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "address",
    "itemId"
  ]
}

  • excel_list_charts

    read

    List charts on a specified Excel worksheet.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetIdOrName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetIdOrName",
    "itemId"
  ]
}

  • excel_get_workbook

    read

    Retrieve an Excel workbook by its storage identifiers.

    Input schema
    {
  "type": "object",
  "properties": {
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_close_session

    unknown

    Close an active Excel workbook session.

    Input schema
    {
  "type": "object",
  "properties": {
    "sessionId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "sessionId",
    "itemId"
  ]
}

  • excel_refresh_all

    unknown

    Refresh all Excel workbook data connections and calculations.

    Input schema
    {
  "type": "object",
  "properties": {
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_get_worksheet

    read

    Retrieve an Excel worksheet by identifier or name.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetIdOrName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetIdOrName",
    "itemId"
  ]
}

  • excel_add_worksheet

    write

    Create a worksheet in an Excel workbook.

    Input schema
    {
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_delete_worksheet

    write

    Delete a specified worksheet from an Excel workbook.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "itemId"
  ]
}

  • excel_activate_worksheet

    unknown

    Activate an Excel worksheet by identifier or name.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetIdOrName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetIdOrName",
    "itemId"
  ]
}

  • excel_get_used_range

    read

    Retrieve the used cell range from an Excel worksheet.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "valuesOnly": {
      "type": "boolean"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "itemId"
  ]
}

  • excel_get_named_range

    read

    Retrieve an Excel named range by name.

    Input schema
    {
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "name",
    "itemId"
  ]
}

  • excel_clear_range

    unknown

    Clear cells in a specified Excel worksheet range.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "address": {
      "type": "string"
    },
    "shift": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "Up"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Down"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Left"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Right"
          ]
        }
      ]
    },
    "applyTo": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "All"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Formats"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Contents"
          ]
        }
      ]
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "address",
    "itemId"
  ]
}

  • excel_insert_range

    write

    Insert cells into a specified Excel worksheet range.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "address": {
      "type": "string"
    },
    "shift": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "Up"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Down"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Left"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Right"
          ]
        }
      ]
    },
    "applyTo": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "All"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Formats"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Contents"
          ]
        }
      ]
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "address",
    "itemId"
  ]
}

  • excel_delete_range

    write

    Delete cells from a specified Excel worksheet range.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "address": {
      "type": "string"
    },
    "shift": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "Up"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Down"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Left"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Right"
          ]
        }
      ]
    },
    "applyTo": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "All"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Formats"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Contents"
          ]
        }
      ]
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "address",
    "itemId"
  ]
}

  • excel_merge_range

    unknown

    Merge cells in a specified Excel worksheet range.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "address": {
      "type": "string"
    },
    "shift": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "Up"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Down"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Left"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Right"
          ]
        }
      ]
    },
    "applyTo": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "All"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Formats"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Contents"
          ]
        }
      ]
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "address",
    "itemId"
  ]
}

  • excel_get_table

    read

    Retrieve an Excel table by identifier or name.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableIdOrName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableIdOrName",
    "itemId"
  ]
}

  • excel_delete_table

    write

    Delete a specified Excel table.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "itemId"
  ]
}

  • excel_clear_table

    unknown

    Clear data from a specified Excel table.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "itemId"
  ]
}

  • excel_list_table_rows

    read

    List rows in a specified Excel table.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "itemId"
  ]
}

  • excel_add_table_rows

    write

    Add rows to an Excel table at an optional index.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {}
      }
    },
    "index": {
      "type": "number"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "values",
    "itemId"
  ]
}

  • excel_delete_table_row

    write

    Delete a specified row from an Excel table.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "rowIndex": {
      "type": "number"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "rowIndex",
    "itemId"
  ]
}

  • excel_list_table_columns

    read

    List columns in a specified Excel table.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "itemId"
  ]
}

  • excel_add_table_column

    write

    Add a column to an Excel table with optional values.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "name": {
      "type": "string"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {}
      }
    },
    "index": {
      "type": "number"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "itemId"
  ]
}

  • excel_delete_table_column

    write

    Delete a specified column from an Excel table.

    Input schema
    {
  "type": "object",
  "properties": {
    "tableId": {
      "type": "string"
    },
    "columnId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "tableId",
    "columnId",
    "itemId"
  ]
}

  • excel_get_chart

    read

    Retrieve an Excel chart by worksheet and chart name.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "chartName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "chartName",
    "itemId"
  ]
}

  • excel_add_chart

    write

    Create an Excel chart from specified worksheet source data.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "type": {
      "type": "string"
    },
    "sourceData": {
      "type": "string"
    },
    "seriesBy": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "Auto"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Rows"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Columns"
          ]
        }
      ]
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "type",
    "sourceData",
    "itemId"
  ]
}

  • excel_delete_chart

    write

    Remove one chart object from a workbook, leaving its source data intact.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "chartName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "chartName",
    "itemId"
  ]
}

  • excel_set_chart_position

    write

    Set an Excel chart position between specified worksheet cells.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "chartName": {
      "type": "string"
    },
    "startCell": {
      "type": "string"
    },
    "endCell": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "chartName",
    "itemId"
  ]
}

  • excel_list_pivot_tables

    read

    List pivot tables on a specified Excel worksheet.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetIdOrName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetIdOrName",
    "itemId"
  ]
}

  • excel_get_pivot_table

    read

    Retrieve an Excel pivot table by worksheet and name.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "pivotName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "pivotName",
    "itemId"
  ]
}

  • excel_add_pivot_table

    write

    Create an Excel pivot table from source data at a destination.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "name": {
      "type": "string"
    },
    "sourceData": {
      "type": "string"
    },
    "destination": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "name",
    "sourceData",
    "destination",
    "itemId"
  ]
}

  • excel_refresh_pivot_table

    unknown

    Refresh a specified Excel pivot table.

    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string"
    },
    "pivotName": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "worksheetId",
    "pivotName",
    "itemId"
  ]
}

  • excel_list_names

    read

    List defined names in an Excel workbook.

    Input schema
    {
  "type": "object",
  "properties": {
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_get_name

    read

    Retrieve an Excel defined name by name.

    Input schema
    {
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "name",
    "itemId"
  ]
}

  • excel_add_name

    write

    Create an Excel defined name referencing a specified range.

    Input schema
    {
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "reference": {
      "type": "string"
    },
    "comment": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "name",
    "reference",
    "itemId"
  ]
}

  • excel_delete_name

    write

    Delete a specified Excel defined name.

    Input schema
    {
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "name",
    "itemId"
  ]
}

  • excel_list_comments

    read

    List comments in an Excel workbook.

    Input schema
    {
  "type": "object",
  "properties": {
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_get_comment

    read

    Retrieve an Excel comment by its identifier.

    Input schema
    {
  "type": "object",
  "properties": {
    "commentId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "commentId",
    "itemId"
  ]
}

  • excel_add_comment

    write

    Add a comment to a specified Excel worksheet cell.

    Input schema
    {
  "type": "object",
  "properties": {
    "cellAddress": {
      "type": "string"
    },
    "content": {
      "type": "string"
    },
    "worksheetId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "cellAddress",
    "content",
    "itemId"
  ]
}

  • excel_delete_comment

    write

    Delete a specified Excel comment.

    Input schema
    {
  "type": "object",
  "properties": {
    "commentId": {
      "type": "string"
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "commentId",
    "itemId"
  ]
}

  • excel_get_application

    read

    Retrieve the Excel application for a workbook session.

    Input schema
    {
  "type": "object",
  "properties": {
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_calculate_application

    read

    Calculate an Excel application using the specified calculation type.

    Input schema
    {
  "type": "object",
  "properties": {
    "calculationType": {
      "oneOf": [
        {
          "type": "string",
          "enum": [
            "Recalculate"
          ]
        },
        {
          "type": "string",
          "enum": [
            "Full"
          ]
        },
        {
          "type": "string",
          "enum": [
            "FullRebuild"
          ]
        }
      ]
    },
    "itemId": {
      "type": "string"
    },
    "siteId": {
      "type": "string"
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": false,
  "required": [
    "itemId"
  ]
}

  • excel_create_session

    write

    Create a workbook session for long-running Excel operations.

    Required paramsitemId
    Input schema
    {
  "type": "object",
  "properties": {
    "persistChanges": {
      "type": "boolean",
      "description": "Persist workbook changes."
    },
    "itemId": {
      "type": "string",
      "description": "Workbook drive item ID."
    },
    "siteId": {
      "type": "string",
      "description": "Optional SharePoint site ID."
    },
    "sessionId": {
      "type": "string"
    }
  },
  "additionalProperties": true,
  "required": [
    "itemId"
  ]
}

  • excel_list_worksheets

    read

    List worksheets in a workbook.

    Required paramsitemId
    Input schema
    {
  "type": "object",
  "properties": {
    "itemId": {
      "type": "string",
      "description": "Workbook drive item ID."
    },
    "siteId": {
      "type": "string",
      "description": "Optional SharePoint site ID."
    },
    "sessionId": {
      "type": "string",
      "description": "Workbook session ID."
    }
  },
  "additionalProperties": true,
  "required": [
    "itemId"
  ]
}

  • excel_get_range

    read

    Read a worksheet range using A1 notation.

    Required paramsitemIdworksheetIdaddress
    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string",
      "description": "Worksheet ID or name."
    },
    "address": {
      "type": "string",
      "description": "A1-style address, e.g. A1:B10."
    },
    "itemId": {
      "type": "string",
      "description": "Workbook drive item ID."
    },
    "siteId": {
      "type": "string",
      "description": "Optional SharePoint site ID."
    },
    "sessionId": {
      "type": "string",
      "description": "Workbook session ID."
    }
  },
  "additionalProperties": true,
  "required": [
    "itemId",
    "worksheetId",
    "address"
  ]
}

  • excel_update_range

    write

    Write values into a worksheet range.

    Required paramsitemIdworksheetIdaddressvalues
    Input schema
    {
  "type": "object",
  "properties": {
    "worksheetId": {
      "type": "string",
      "description": "Worksheet ID or name."
    },
    "address": {
      "type": "string",
      "description": "A1-style address."
    },
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {}
      },
      "description": "2D array of values to write."
    },
    "formulas": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {}
      }
    },
    "numberFormat": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {}
      }
    },
    "itemId": {
      "type": "string",
      "description": "Workbook drive item ID."
    },
    "siteId": {
      "type": "string",
      "description": "Optional SharePoint site ID."
    },
    "sessionId": {
      "type": "string",
      "description": "Workbook session ID."
    }
  },
  "additionalProperties": true,
  "required": [
    "itemId",
    "worksheetId",
    "address",
    "values"
  ]
}