excel_search_value
Search for a specific value within an Excel sheet or range, with optional case sensitivity, to locate data quickly.
Instructions
Search for a value in sheet/range
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"filePath": "<filePath>",
"sheetName": "<sheetName>",
"searchValue": "<searchValue>"
},
"name": "excel_search_value"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePath | Yes | Path to the Excel file | |
| sheetName | Yes | Name of the sheet | |
| searchValue | Yes | Value to search for | |
| range | No | Optional range to search within | |
| caseSensitive | No | ||
| responseFormat | No | json |