All tools

Files & calendar · excel_find_rows

Find rows in an Excel workbook (OneDrive)

Rows of an Excel worksheet in OneDrive / SharePoint whose column equals a given value (request reference, customer).

Price
included
Requirements
SharePoint / OneDrive
set it up in Settings → Integrations
Human approval
No
read or internal write
Reliability
Verified
stable · 0.8 s

Input

FieldTypeDescription
file *stringWorkbook ref (item:<driveId>:<itemId>), item id, or share URL.
worksheetstringWorksheet name (default: first).
column *stringColumn letter or header label to search.
value *stringValue to match exactly (case-insensitive).
maxRowsnumberMax matching rows returned (default 20).

Call this tool

Through the HTTP API, or from the MCP server with the run meta-tool.

curl https://api.ezyagents.fr/gateway/v1/run \
  -H "Authorization: Bearer ezk_…" -H "Content-Type: application/json" \
  -d '{"tool":"excel_find_rows","input":{"file":"…","worksheet":"…","column":"…","value":"…"}}'
$run({ "tool": "excel_find_rows", "input": {"file":"…","worksheet":"…","column":"…","value":"…"} })