{"uid":"cap_JPg4Lu6fKRpn2-CMoprP1","slug":"aurelianflo-xlsx-workbook-generator-1f202270","name":"AurelianFlo XLSX Workbook Generator","description":"Create finance-ready XLSX workbooks from structured sheets, Markdown/HTML tables, or report payloads for exports and analysis packs.","url":"https://api.aurelianflo.com/api/tools/xlsx/generate","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","bodyType","body","method"],"properties":{"body":{"oneOf":[{"type":"object","required":["report_meta"],"properties":{"result":{"type":"object","additionalProperties":true},"tables":{"type":"object","additionalProperties":{"type":"object","properties":{"rows":{"type":"array","items":{"oneOf":[{"type":"object","additionalProperties":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}},{"type":"array","items":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}}]}},"columns":{"type":"array","items":{"type":"string"}}},"additionalProperties":true}},"chart_hints":{"type":"array","items":{"type":"object","additionalProperties":true}},"report_meta":{"type":"object","properties":{"date":{"type":"string"},"name":{"type":"string"},"owner":{"type":"string"},"title":{"type":"string"},"author":{"type":"string"},"version":{"type":"string"},"report_type":{"type":"string"},"report_title":{"type":"string"}},"additionalProperties":true},"export_artifacts":{"type":"object","properties":{"workbook_rows":{"type":"object","additionalProperties":{"type":"array","items":{"oneOf":[{"type":"object","additionalProperties":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}},{"type":"array","items":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}}]}}}},"additionalProperties":true},"headline_metrics":{"type":"array","items":{"type":"object","required":["label"],"properties":{"unit":{"type":"string"},"label":{"type":"string"},"value":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}},"additionalProperties":true}},"executive_summary":{"type":"array","items":{"type":"string"}}},"additionalProperties":true},{"type":"object","anyOf":[{"required":["title","sheets"]},{"required":["html"]},{"required":["markdown"]},{"required":["tables"]}],"properties":{"html":{"type":"string"},"title":{"type":"string"},"sheets":{"type":"array","items":{"type":"object","required":["name","rows"],"properties":{"name":{"type":"string"},"rows":{"type":"array","items":{"oneOf":[{"type":"object","additionalProperties":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}},{"type":"array","items":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}}]}},"columns":{"type":"array","items":{"type":"string"}},"headers":{"type":"array","items":{"type":"string"}},"formulas":{"type":"array","items":{"type":"object","additionalProperties":true}}},"additionalProperties":true}},"tables":{"type":"array","items":{"type":"object","properties":{"rows":{"type":"array","items":{"oneOf":[{"type":"object","additionalProperties":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}},{"type":"array","items":{"oneOf":[{"type":"string"},{"type":"number"},{"type":"integer"},{"type":"boolean"},{"type":"null"}]}}]}},"columns":{"type":"array","items":{"type":"string"}}},"additionalProperties":true}},"markdown":{"type":"string"},"metadata":{"type":"object","additionalProperties":true},"template":{"type":"string"}},"additionalProperties":true}]},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["success","data","source"],"properties":{"data":{"type":"object","required":["documentType","fileName","mimeType","artifact"],"properties":{"preview":{"type":"array","items":{"type":"string"}},"artifact":{"type":"object","required":["type","name","sizeBytes","contentBase64"],"properties":{"name":{"type":"string"},"type":{"type":"string"},"sizeBytes":{"type":"integer"},"contentBase64":{"type":"string"}},"additionalProperties":true},"fileName":{"type":"string"},"mimeType":{"type":"string"},"capabilities":{"type":"object","additionalProperties":true},"documentType":{"type":"string"}},"additionalProperties":true},"source":{"type":"string"},"success":{"type":"boolean"}},"additionalProperties":true}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.12","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.12/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.12","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.12","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_FglTwCZjr89dihW_kPKmx","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.12","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Generates finance-ready XLSX workbooks from structured sheet data, Markdown/HTML tables, or report payloads for exports and analysis packs.","exampleAgentPrompt":"Can you generate a finance-ready Excel workbook from this report? The report is titled 'Q2 Revenue Summary', authored by 'Jane Smith', dated 2024-06-30, with a table called 'revenue' that has columns ['Month','Revenue','Expenses','Net'] and three rows of data, plus headline metrics for Total Revenue ($1.2M) and Net Profit ($340K).","exampleUseCases":null,"resultDescription":"Returns a binary XLSX workbook file (or a download URL/base64 payload) containing one or more formatted sheets with the provided tabular data, headline metrics, executive summary, and report metadata — ready for finance handoffs or analysis.","failureModes":["Missing required 'input.type', 'input.bodyType', 'input.body', or 'input.method' fields returns a 400 validation error","Malformed table rows (wrong data types in cells) cause schema validation failure","Payment not included or insufficient funds results in a 402 Payment Required response","Oversized payloads with very large workbook_rows may time out or be rejected","Invalid report_meta date format may produce malformed workbook metadata"],"whenToPreferThis":"Choose this endpoint when you need to programmatically produce a downloadable, finance-ready XLSX file from structured JSON data, Markdown tables, or HTML tables — especially for report exports, audit packs, or financial handoffs where Excel format is required. Prefer over CSV generation when multi-sheet workbooks, headline metrics, or report metadata are needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T12:40:10.214Z","isFirstParty":false}