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

> Workbook and worksheet operations

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

## Tools

| Tool                                                                              | Description                                                                                                                                                                                                        |
| --------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [`microsoft-excel_create_workbook`](#microsoft-excel_create_workbook)             | Create new Microsoft Excel workbook                                                                                                                                                                                |
| [`microsoft-excel_create_worksheet`](#microsoft-excel_create_worksheet)           | Create new worksheet in Microsoft Excel workbook                                                                                                                                                                   |
| [`microsoft-excel_list_workbooks`](#microsoft-excel_list_workbooks)               | List Microsoft Excel workbooks from the root directory or a specific folder                                                                                                                                        |
| [`microsoft-excel_list_worksheets`](#microsoft-excel_list_worksheets)             | List Microsoft Excel worksheets in a workbook                                                                                                                                                                      |
| [`microsoft-excel_read_data`](#microsoft-excel_read_data)                         | Read data from Microsoft Excel worksheet                                                                                                                                                                           |
| [`microsoft-excel_write_data`](#microsoft-excel_write_data)                       | Write data to Microsoft Excel worksheet                                                                                                                                                                            |
| [`microsoft-excel_bulk_update_data`](#microsoft-excel_bulk_update_data)           | Update multiple ranges in a single Microsoft Excel worksheet in one batched call. Use this to set several non-contiguous ranges or cells at once (e.g. A1, C5, F10:G11) instead of calling write\_data repeatedly. |
| [`microsoft-excel_rename_worksheet`](#microsoft-excel_rename_worksheet)           | Rename worksheet in Microsoft Excel workbook                                                                                                                                                                       |
| [`microsoft-excel_get_workbook_metadata`](#microsoft-excel_get_workbook_metadata) | Get metadata about workbook including sheets, ranges, etc.                                                                                                                                                         |
| [`microsoft-excel_delete_worksheet`](#microsoft-excel_delete_worksheet)           | Delete worksheet from Microsoft Excel workbook                                                                                                                                                                     |
| [`microsoft-excel_delete_workbook`](#microsoft-excel_delete_workbook)             | Delete a Microsoft Excel workbook                                                                                                                                                                                  |

***

## microsoft-excel\_create\_workbook

Create new Microsoft Excel workbook

**Parameters:**

| Parameter  | Type   | Required | Default | Description                   |
| ---------- | ------ | -------- | ------- | ----------------------------- |
| `fileName` | string | Yes      | —       | Name of the new workbook file |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "fileName": {
        "type": "string",
        "description": "Name of the new workbook file"
      }
    },
    "required": [
      "PCID",
      "fileName"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_create\_worksheet

Create new worksheet in Microsoft Excel workbook

**Parameters:**

| Parameter    | Type   | Required | Default | Description                            |
| ------------ | ------ | -------- | ------- | -------------------------------------- |
| `workbookId` | string | Yes      | —       | Workbook ID to create the worksheet in |
| `sheetName`  | string | Yes      | —       | Name of the new worksheet              |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "Workbook ID to create the worksheet in"
      },
      "sheetName": {
        "type": "string",
        "description": "Name of the new worksheet"
      }
    },
    "required": [
      "PCID",
      "workbookId",
      "sheetName"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_list\_workbooks

List Microsoft Excel workbooks from the root directory or a specific folder

**Parameters:**

| Parameter | Type   | Required | Default | Description                                                |
| --------- | ------ | -------- | ------- | ---------------------------------------------------------- |
| `driveId` | string | No       | —       | Optional drive ID to list workbooks from a specific folder |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "driveId": {
        "type": "string",
        "description": "Optional drive ID to list workbooks from a specific folder"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_list\_worksheets

List Microsoft Excel worksheets in a workbook

**Parameters:**

| Parameter    | Type   | Required | Default | Description                         |
| ------------ | ------ | -------- | ------- | ----------------------------------- |
| `workbookId` | string | Yes      | —       | Workbook ID to list worksheets from |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "Workbook ID to list worksheets from"
      }
    },
    "required": [
      "PCID",
      "workbookId"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_read\_data

Read data from Microsoft Excel worksheet

**Parameters:**

| Parameter    | Type   | Required | Default | Description                                           |
| ------------ | ------ | -------- | ------- | ----------------------------------------------------- |
| `workbookId` | string | Yes      | —       | Workbook ID to read data from                         |
| `sheetName`  | string | Yes      | —       | Worksheet name to read data from                      |
| `startCell`  | string | No       | `"A1"`  | Starting cell of the range to read (defaults to "A1") |
| `endCell`    | string | No       | —       | Ending cell of the range to read (e.g., "B10")        |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "Workbook ID to read data from"
      },
      "sheetName": {
        "type": "string",
        "description": "Worksheet name to read data from"
      },
      "startCell": {
        "type": "string",
        "default": "A1",
        "description": "Starting cell of the range to read (defaults to \"A1\")"
      },
      "endCell": {
        "type": "string",
        "description": "Ending cell of the range to read (e.g., \"B10\")"
      }
    },
    "required": [
      "PCID",
      "workbookId",
      "sheetName"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_write\_data

Write data to Microsoft Excel worksheet

**Parameters:**

| Parameter    | Type         | Required | Default | Description                                                 |
| ------------ | ------------ | -------- | ------- | ----------------------------------------------------------- |
| `workbookId` | string       | Yes      | —       | Workbook ID to write data to                                |
| `sheetName`  | string       | Yes      | —       | Worksheet name to write data to                             |
| `data`       | string\[]\[] | Yes      | —       | Array of rows                                               |
| `startCell`  | string       | No       | `"A1"`  | Starting cell where data will be written (defaults to "A1") |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "Workbook ID to write data to"
      },
      "sheetName": {
        "type": "string",
        "description": "Worksheet name to write data to"
      },
      "data": {
        "type": "array",
        "items": {
          "type": "array",
          "items": {
            "oneOf": [
              {
                "type": "string"
              },
              {
                "type": "number"
              },
              {
                "type": "boolean"
              }
            ]
          },
          "description": "Array of cell values"
        },
        "description": "Array of rows"
      },
      "startCell": {
        "type": "string",
        "default": "A1",
        "description": "Starting cell where data will be written (defaults to \"A1\")"
      }
    },
    "required": [
      "PCID",
      "workbookId",
      "sheetName",
      "data"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_bulk\_update\_data

Update multiple ranges in a single Microsoft Excel worksheet in one batched call. Use this to set several non-contiguous ranges or cells at once (e.g. A1, C5, F10:G11) instead of calling write\_data repeatedly.

**Parameters:**

| Parameter    | Type      | Required | Default | Description                          |
| ------------ | --------- | -------- | ------- | ------------------------------------ |
| `workbookId` | string    | Yes      | —       | Workbook ID to update                |
| `sheetName`  | string    | Yes      | —       | Worksheet name to update             |
| `updates`    | object\[] | Yes      | —       | List of range/value updates to apply |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "Workbook ID to update"
      },
      "sheetName": {
        "type": "string",
        "description": "Worksheet name to update"
      },
      "updates": {
        "type": "array",
        "items": {
          "type": "object",
          "properties": {
            "range": {
              "type": "string",
              "description": "Target range in A1 notation, e.g. 'A1', 'C5', or 'F10:G11'"
            },
            "values": {
              "type": "array",
              "items": {
                "type": "array",
                "items": {
                  "oneOf": [
                    {
                      "type": "string"
                    },
                    {
                      "type": "number"
                    },
                    {
                      "type": "boolean"
                    },
                    {
                      "type": "null"
                    }
                  ]
                },
                "description": "Array of cell values"
              },
              "description": "2D array of values matching the range dimensions"
            }
          }
        },
        "description": "List of range/value updates to apply"
      }
    },
    "required": [
      "PCID",
      "workbookId",
      "sheetName",
      "updates"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_rename\_worksheet

Rename worksheet in Microsoft Excel workbook

**Parameters:**

| Parameter    | Type   | Required | Default | Description                                    |
| ------------ | ------ | -------- | ------- | ---------------------------------------------- |
| `workbookId` | string | Yes      | —       | Workbook ID containing the worksheet to rename |
| `oldName`    | string | Yes      | —       | Current name of the worksheet                  |
| `newName`    | string | Yes      | —       | New name for the worksheet                     |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "Workbook ID containing the worksheet to rename"
      },
      "oldName": {
        "type": "string",
        "description": "Current name of the worksheet"
      },
      "newName": {
        "type": "string",
        "description": "New name for the worksheet"
      }
    },
    "required": [
      "PCID",
      "workbookId",
      "oldName",
      "newName"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_get\_workbook\_metadata

Get metadata about workbook including sheets, ranges, etc.

**Parameters:**

| Parameter       | Type    | Required | Default | Description                                     |
| --------------- | ------- | -------- | ------- | ----------------------------------------------- |
| `workbookId`    | string  | Yes      | —       | Workbook ID to get metadata for                 |
| `includeRanges` | boolean | No       | `false` | Whether to include named ranges in the metadata |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "Workbook ID to get metadata for"
      },
      "includeRanges": {
        "type": "boolean",
        "default": false,
        "description": "Whether to include named ranges in the metadata"
      }
    },
    "required": [
      "PCID",
      "workbookId"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_delete\_worksheet

Delete worksheet from Microsoft Excel workbook

**Parameters:**

| Parameter    | Type   | Required | Default | Description                                    |
| ------------ | ------ | -------- | ------- | ---------------------------------------------- |
| `workbookId` | string | Yes      | —       | Workbook ID containing the worksheet to delete |
| `sheetName`  | string | Yes      | —       | Name of the worksheet to delete                |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "Workbook ID containing the worksheet to delete"
      },
      "sheetName": {
        "type": "string",
        "description": "Name of the worksheet to delete"
      }
    },
    "required": [
      "PCID",
      "workbookId",
      "sheetName"
    ]
  }
  ```
</Expandable>

***

## microsoft-excel\_delete\_workbook

Delete a Microsoft Excel workbook

**Parameters:**

| Parameter    | Type   | Required | Default | Description                  |
| ------------ | ------ | -------- | ------- | ---------------------------- |
| `workbookId` | string | Yes      | —       | ID of the workbook to delete |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "workbookId": {
        "type": "string",
        "description": "ID of the workbook to delete"
      }
    },
    "required": [
      "PCID",
      "workbookId"
    ]
  }
  ```
</Expandable>