> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# 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`](#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`](#microsoft-365-excel_create_workbook)             | Create a new empty Excel workbook in OneDrive root                                                                                                                                                                                                                     |
| [`microsoft-365-excel_create_worksheet`](#microsoft-365-excel_create_worksheet)           | Create a new worksheet in an existing Excel workbook                                                                                                                                                                                                                   |
| [`microsoft-365-excel_delete_workbook`](#microsoft-365-excel_delete_workbook)             | Delete an Excel workbook from OneDrive                                                                                                                                                                                                                                 |
| [`microsoft-365-excel_delete_worksheet`](#microsoft-365-excel_delete_worksheet)           | Delete a worksheet from an Excel workbook                                                                                                                                                                                                                              |
| [`microsoft-365-excel_get_workbook_metadata`](#microsoft-365-excel_get_workbook_metadata) | Get metadata about an Excel workbook, optionally including worksheet list                                                                                                                                                                                              |
| [`microsoft-365-excel_list_workbooks`](#microsoft-365-excel_list_workbooks)               | List Excel workbooks (.xlsx, .xlsm, .xls) in OneDrive. Optionally list from a specific folder.                                                                                                                                                                         |
| [`microsoft-365-excel_list_worksheets`](#microsoft-365-excel_list_worksheets)             | List worksheets in an Excel workbook                                                                                                                                                                                                                                   |
| [`microsoft-365-excel_read_worksheet_data`](#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`](#microsoft-365-excel_rename_worksheet)           | Rename a worksheet in an Excel workbook                                                                                                                                                                                                                                |
| [`microsoft-365-excel_write_worksheet_data`](#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.         |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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   |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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 |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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    |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>

***

## 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")                                   |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "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"
    ]
  }
  ```
</Expandable>