Generate an Excel file with formulas from an LLM

​

The problem in practice

• The model tends to write the already computed result: the sheet looks right but doesn’t update when a value changes.
• The formulas it writes can point at the wrong cells and end up as #REF! or #DIV/0!.
• When the file is built with code, formulas aren’t calculated until someone opens it, so errors go unnoticed.
• Newer functions like XLOOKUP or FILTER don’t work in every version of Excel.

​

The solution with Doconda

from pathlib import Path
from doconda import Doconda

doconda = Doconda()  # reads the key from DOCONDA_API_KEY
doc = doconda.documents.create(
    format="xlsx",
    prompt="12-month revenue forecast: 1,000 customers at the start, 5% monthly growth and €20 per customer",
)
Path("forecast.xlsx").write_bytes(doconda.documents.download(doc["id"], "xlsx"))

import { writeFile } from "node:fs/promises"
import { Doconda } from "@doconda/sdk"

const doconda = new Doconda()
const doc = await doconda.documents.create({
  format: "xlsx",
  prompt: "12-month revenue forecast: 1,000 customers at the start, 5% monthly growth and €20 per customer",
})
await writeFile("forecast.xlsx", await doconda.documents.download(doc.id, "xlsx"))

​

What you get back

• An .xlsx with formulas: change an assumption and the sheet recalculates. Its PDF too.
• status: ready, ready_with_warnings, needs_review or failed (not charged).
• A report (documents.report(id)). Figures that don’t come from your request or your sources are removed or flagged for you to check.

​

FAQ

​

Keep reading

• Create: formats, sources and quality levels.
• Review: the list of issues detected in Excel.
• Python SDK and TypeScript SDK.
• Doconda in your agent.
• Examples on GitHub.