microsoft-365-excel

Microsoft 365 Excel — create and manage Excel workbooks, worksheets, and cell data in OneDrive

Server path: /microsoft-365-excel | Type: Application | PCID required: Yes

Tools

Tool	Description
microsoft-365-excel_bulk_update_data	Update multiple worksheet ranges in a single call using the Microsoft Graph $batch endpoint. Each update targets a range (in A1 notation) on a worksheet and supplies a 2D array of values. Returns a per-range result so partial failures are reported individually.
microsoft-365-excel_create_workbook	Create a new empty Excel workbook in OneDrive root
microsoft-365-excel_create_worksheet	Create a new worksheet in an existing Excel workbook
microsoft-365-excel_delete_workbook	Delete an Excel workbook from OneDrive
microsoft-365-excel_delete_worksheet	Delete a worksheet from an Excel workbook
microsoft-365-excel_get_workbook_metadata	Get metadata about an Excel workbook, optionally including worksheet list
microsoft-365-excel_list_workbooks	List Excel workbooks (.xlsx, .xlsm, .xls) in OneDrive. Optionally list from a specific folder.
microsoft-365-excel_list_worksheets	List worksheets in an Excel workbook
microsoft-365-excel_read_worksheet_data	Read cell data from an Excel worksheet. Specify a range (e.g. “A1:D10”) or omit to read the entire used range.
microsoft-365-excel_rename_worksheet	Rename a worksheet in an Excel workbook
microsoft-365-excel_write_worksheet_data	Write a 2D array of values to an Excel worksheet range. Calculates the target range automatically from the data dimensions.

---

microsoft-365-excel_bulk_update_data

Update multiple worksheet ranges in a single call using the Microsoft Graph $batch endpoint. Each update targets a range (in A1 notation) on a worksheet and supplies a 2D array of values. Returns a per-range result so partial failures are reported individually.

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The drive item ID of the Excel workbook
updates	object[]	Yes	—	List of range updates to apply.

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The drive item ID of the Excel workbook"
    },
    "updates": {
      "type": "array",
      "description": "List of range updates to apply.",
      "items": {
        "type": "object",
        "properties": {
          "sheet_name": {
            "type": "string",
            "description": "Worksheet name"
          },
          "range_address": {
            "type": "string",
            "description": "Target range in A1 notation, e.g. 'A1:C5'"
          },
          "values": {
            "type": "array",
            "description": "2D array of cell values: an array of rows, each an array of column values.",
            "items": {
              "type": "array",
              "items": {}
            }
          }
        },
        "required": [
          "sheet_name",
          "range_address",
          "values"
        ]
      }
    }
  },
  "required": [
    "PCID",
    "workbook_id",
    "updates"
  ]
}

---

microsoft-365-excel_create_workbook

Create a new empty Excel workbook in OneDrive root

Parameters:

Parameter	Type	Required	Default	Description
file_name	string	Yes	—	Name for the new workbook. Extension .xlsx will be added if not present.

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "file_name": {
      "type": "string",
      "description": "Name for the new workbook. Extension .xlsx will be added if not present."
    }
  },
  "required": [
    "PCID",
    "file_name"
  ]
}

---

microsoft-365-excel_create_worksheet

Create a new worksheet in an existing Excel workbook

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The ID of the Excel workbook
sheet_name	string	Yes	—	Name for the new worksheet

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The ID of the Excel workbook"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name for the new worksheet"
    }
  },
  "required": [
    "PCID",
    "workbook_id",
    "sheet_name"
  ]
}

---

microsoft-365-excel_delete_workbook

Delete an Excel workbook from OneDrive

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The ID of the Excel workbook to delete

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The ID of the Excel workbook to delete"
    }
  },
  "required": [
    "PCID",
    "workbook_id"
  ]
}

---

microsoft-365-excel_delete_worksheet

Delete a worksheet from an Excel workbook

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The ID of the Excel workbook
sheet_name	string	Yes	—	Name of the worksheet to delete

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The ID of the Excel workbook"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet to delete"
    }
  },
  "required": [
    "PCID",
    "workbook_id",
    "sheet_name"
  ]
}

---

microsoft-365-excel_get_workbook_metadata

Get metadata about an Excel workbook, optionally including worksheet list

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The ID of the Excel workbook
include_worksheets	boolean	No	—	Include the list of worksheets in the response

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The ID of the Excel workbook"
    },
    "include_worksheets": {
      "type": "boolean",
      "description": "Include the list of worksheets in the response"
    }
  },
  "required": [
    "PCID",
    "workbook_id"
  ]
}

---

microsoft-365-excel_list_workbooks

List Excel workbooks (.xlsx, .xlsm, .xls) in OneDrive. Optionally list from a specific folder.

Parameters:

Parameter	Type	Required	Default	Description
folder_id	string	No	—	Optional folder ID to list workbooks from a specific folder

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "folder_id": {
      "type": "string",
      "description": "Optional folder ID to list workbooks from a specific folder"
    }
  },
  "required": [
    "PCID"
  ]
}

---

microsoft-365-excel_list_worksheets

List worksheets in an Excel workbook

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The ID of the Excel workbook

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The ID of the Excel workbook"
    }
  },
  "required": [
    "PCID",
    "workbook_id"
  ]
}

---

microsoft-365-excel_read_worksheet_data

Read cell data from an Excel worksheet. Specify a range (e.g. “A1:D10”) or omit to read the entire used range.

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The ID of the Excel workbook
sheet_name	string	Yes	—	Name of the worksheet to read from
start_cell	string	No	—	Start cell reference (e.g. “A1”). Omit to read entire used range.
end_cell	string	No	—	End cell reference (e.g. “D10”). Required if start_cell is provided.

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The ID of the Excel workbook"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet to read from"
    },
    "start_cell": {
      "type": "string",
      "description": "Start cell reference (e.g. \"A1\"). Omit to read entire used range."
    },
    "end_cell": {
      "type": "string",
      "description": "End cell reference (e.g. \"D10\"). Required if start_cell is provided."
    }
  },
  "required": [
    "PCID",
    "workbook_id",
    "sheet_name"
  ]
}

---

microsoft-365-excel_rename_worksheet

Rename a worksheet in an Excel workbook

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The ID of the Excel workbook
old_name	string	Yes	—	Current name of the worksheet
new_name	string	Yes	—	New name for the worksheet

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The ID of the Excel workbook"
    },
    "old_name": {
      "type": "string",
      "description": "Current name of the worksheet"
    },
    "new_name": {
      "type": "string",
      "description": "New name for the worksheet"
    }
  },
  "required": [
    "PCID",
    "workbook_id",
    "old_name",
    "new_name"
  ]
}

---

microsoft-365-excel_write_worksheet_data

Write a 2D array of values to an Excel worksheet range. Calculates the target range automatically from the data dimensions.

Parameters:

Parameter	Type	Required	Default	Description
workbook_id	string	Yes	—	The ID of the Excel workbook
sheet_name	string	Yes	—	Name of the worksheet to write to
data	any[]	Yes	—	2D array of values to write (array of rows, each row is an array of cell values)
start_cell	string	No	—	Top-left cell to start writing (default: “A1”)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "workbook_id": {
      "type": "string",
      "description": "The ID of the Excel workbook"
    },
    "sheet_name": {
      "type": "string",
      "description": "Name of the worksheet to write to"
    },
    "data": {
      "type": "array",
      "description": "2D array of values to write (array of rows, each row is an array of cell values)"
    },
    "start_cell": {
      "type": "string",
      "description": "Top-left cell to start writing (default: \"A1\")"
    }
  },
  "required": [
    "PCID",
    "workbook_id",
    "sheet_name",
    "data"
  ]
}