Convert spreadsheet
convert_spreadsheetCompile an uploaded .xlsx workbook's OWN formulas into a ready ModelSpec — deterministic transpilation (Excel formula language -> JSONata), never an LLM call: every number the compiled spec computes is checked to exactly match what the source workbook itself computed. One worksheet, one header-row table, a bounded numeric/boolean function set (IF/AND/OR/NOT/ROUND/ABS/SUM/AVERAGE/MIN/MAX/COUNT) — anything else (VLOOKUP, cross-sheet refs, non-uniform per-row formulas, …) is named and reported in rejectedColumns rather than guessed; the rest of the sheet still compiles. The returned spec is NOT yet registered — review it, then call create_model yourself.
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": {
"data": "<data>",
"filename": "<filename>",
"modelId": "<modelId>"
},
"name": "convert_spreadsheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | The .xlsx file content, base64-encoded. | |
| modelId | Yes | The desired model id for the compiled spec. | |
| filename | Yes | Original filename, e.g. 'pricing.xlsx'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spec | No | The compiled ModelSpec (only present when valid). | |
| valid | No | True if at least one column compiled. | |
| rejectedColumns | No | Columns that could not be translated: {header, reason, detail}. |