Excel

Methods (54)

• excel_create_session

  write

  Create a workbook session for long-running Excel operations.

  Required paramsitemId
  Input schema

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

• 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."
      }
    },
    "required": [
      "itemId"
    ],
    "additionalProperties": true
  }

• excel_get_range

  read

  Read a worksheet range using A1 notation.

  Required paramsitemIdworksheetIdaddress
  Input schema

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

• excel_update_range

  write

  Write values into a worksheet range.

  Required paramsitemIdworksheetIdaddressvalues
  Input schema

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

• excel_list_tables

  read

• excel_add_table

  write

• excel_list_charts

  read

• excel_call_function

  unknown

• excel_get_workbook

  read

• excel_close_session

  unknown

• excel_refresh_all

  unknown

• excel_get_worksheet

  read

• excel_add_worksheet

  write

• excel_delete_worksheet

  write

• excel_activate_worksheet

  unknown

• excel_get_used_range

  read

• excel_get_named_range

  read

• excel_clear_range

  unknown

• excel_insert_range

  write

• excel_delete_range

  write

• excel_merge_range

  unknown

• excel_unmerge_range

  unknown

• excel_get_table

  read

• excel_delete_table

  write

• excel_clear_table

  unknown

• excel_convert_table_to_range

  unknown

• excel_list_table_rows

  read

• excel_add_table_rows

  write

• excel_delete_table_row

  write

• excel_list_table_columns

  read

• excel_add_table_column

  write

• excel_delete_table_column

  write

• excel_get_chart

  read

• excel_add_chart

  write

• excel_delete_chart

  write

• excel_set_chart_position

  write

• excel_list_pivot_tables

  read

• excel_get_pivot_table

  read

• excel_add_pivot_table

  write

• excel_refresh_pivot_table

  unknown

• excel_list_names

  read

• excel_get_name

  read

• excel_add_name

  write

• excel_delete_name

  write

• excel_list_comments

  read

• excel_get_comment

  read

• excel_add_comment

  write

• excel_delete_comment

  write

• excel_protect_workbook

  unknown

• excel_unprotect_workbook

  unknown

• excel_protect_worksheet

  unknown

• excel_unprotect_worksheet

  unknown

• excel_get_application

  read

• excel_calculate_application

  read