← All toolsFiles & Documentsxlsx_handlerAll editions

ANALYZE_XLSX

Runs a sandboxed pandas expression on a spreadsheet. The DataFrame is 'df'. Examples: df.describe(), df.groupby('Region')['Sales'].sum(), df[df['Age'] > 30].shape[0]

Parameters

NameTypeRequiredDescription
pathstringyesAbsolute path to the .xlsx or .csv file
expressionstringyesPandas expression to evaluate (df is the DataFrame)
sheet_namestring—Sheet name (default: first sheet)

How to use it

You normally trigger this by describing what you want in chat — the agent selects ANALYZE_XLSX automatically. For example:

Try saying
“use xlsx handler to analyze …”

In a workflow

As a step in a multi-step workflow DAG:

json
{
  "id": "s1",
  "agent": "xlsx_handler",
  "action": "ANALYZE_XLSX",
  "args": {
    "path": "/Users/me/Documents/file.txt",
    "expression": "…",
    "sheet_name": "…"
  },
  "depends_on": [],
  "outputs": []
}

Direct call

For scripting, call it directly via POST /execute_tool. Every tool returns { success, message, data }.

bash
curl -X POST http://127.0.0.1:8000/execute_tool \
  -H "Content-Type: application/json" \
  -d '{"tool_name":"ANALYZE_XLSX","args":{"path":"/Users/me/Documents/file.txt","expression":"…","sheet_name":"…"}}'

Part of the xlsx_handler plugin. Browse the full Plugin & Tool Catalog or the relevant feature guide.