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.
Server path: /microsoft-excel | Type: Application | PCID required: Yes
| Tool | Description |
|---|
microsoft-excel_create_workbook | Create new Microsoft Excel workbook |
microsoft-excel_create_worksheet | Create new worksheet in Microsoft Excel workbook |
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_write_data | Write data to Microsoft Excel worksheet |
microsoft-excel_rename_worksheet | Rename worksheet in Microsoft Excel workbook |
microsoft-excel_get_workbook_metadata | Get metadata about workbook including sheets, ranges, etc. |
microsoft-excel_delete_worksheet | Delete worksheet from Microsoft Excel 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 |
{
"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 |
{
"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_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 |
{
"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 |
{
"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”) |
{
"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_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”) |
{
"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"
]
}
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 |
{
"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"
]
}
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 |
{
"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_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 |
{
"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_delete_workbook
Delete a Microsoft Excel workbook
Parameters:
| Parameter | Type | Required | Default | Description |
|---|
workbookId | string | Yes | — | ID of the workbook to delete |
{
"type": "object",
"properties": {
"PCID": {
"type": "string",
"description": "Pink Connect ID"
},
"workbookId": {
"type": "string",
"description": "ID of the workbook to delete"
}
},
"required": [
"PCID",
"workbookId"
]
}
