microsoft-365-excel - Pinkfish - AI Agents & Workflows for Getting Work Done

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

​Tools

​microsoft-365-excel_bulk_update_data

​microsoft-365-excel_create_workbook

​microsoft-365-excel_create_worksheet

​microsoft-365-excel_delete_workbook

​microsoft-365-excel_delete_worksheet

​microsoft-365-excel_get_workbook_metadata

​microsoft-365-excel_list_workbooks

​microsoft-365-excel_list_worksheets

​microsoft-365-excel_read_worksheet_data

​microsoft-365-excel_rename_worksheet

​microsoft-365-excel_write_worksheet_data

Tools

microsoft-365-excel_bulk_update_data

microsoft-365-excel_create_workbook

microsoft-365-excel_create_worksheet

microsoft-365-excel_delete_workbook

microsoft-365-excel_delete_worksheet

microsoft-365-excel_get_workbook_metadata

microsoft-365-excel_list_workbooks

microsoft-365-excel_list_worksheets

microsoft-365-excel_read_worksheet_data

microsoft-365-excel_rename_worksheet

microsoft-365-excel_write_worksheet_data