microsoft-excel

Workbook and worksheet operations

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

Tools

Tool	Description
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_create_workbook	Create new Microsoft Excel workbook
microsoft-excel_create_worksheet	Create new worksheet in Microsoft Excel workbook
microsoft-excel_delete_workbook	Delete a Microsoft Excel workbook
microsoft-excel_delete_worksheet	Delete worksheet from Microsoft Excel workbook
microsoft-excel_get_workbook_metadata	Get metadata about workbook including sheets, ranges, etc.
microsoft-excel_list_workbooks	List Microsoft Excel workbooks from the root directory or a specific folder
microsoft-excel_list_worksheets	List Microsoft Excel worksheets in a workbook
microsoft-excel_read_data	Read data from Microsoft Excel worksheet
microsoft-excel_rename_worksheet	Rename worksheet in Microsoft Excel workbook
microsoft-excel_write_data	Write data to Microsoft Excel worksheet

---

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

Show inputSchema

{
  "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"
  ]
}

---

microsoft-excel_create_workbook

Create new Microsoft Excel workbook

Parameters:

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "fileName": {
      "type": "string",
      "description": "Name of the new workbook file"
    }
  },
  "required": [
    "PCID",
    "fileName"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

microsoft-excel_delete_workbook

Delete a Microsoft Excel workbook

Parameters:

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "workbookId": {
      "type": "string",
      "description": "ID of the workbook to delete"
    }
  },
  "required": [
    "PCID",
    "workbookId"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID"
    },
    "workbookId": {
      "type": "string",
      "description": "Workbook ID to list worksheets from"
    }
  },
  "required": [
    "PCID",
    "workbookId"
  ]
}

---

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”)

Show inputSchema

{
  "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"
  ]
}

---

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

Show inputSchema

{
  "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"
  ]
}

---

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”)

Show inputSchema

{
  "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"
  ]
}