¿Cómo editar un Excel con IA sin perder las fórmulas?

from pathlib import Path
from doconda import Doconda

doconda = Doconda()  # lee la key de DOCONDA_API_KEY
file = doconda.files.upload("ventas.xlsx")
edited = doconda.documents.create(
    operation="edit",
    file=file["id"],
    prompt="Añade una columna Margen en la hoja Ventas: ingresos menos costes, y un total al final",
)
report = doconda.documents.report(edited["id"])
for issue in report["issues"]:
    print(issue["code"], issue["message"], issue["location"])
Path("ventas-editado.xlsx").write_bytes(doconda.documents.download(edited["id"], "xlsx"))

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

const doconda = new Doconda()
const file = await doconda.files.upload(await readFile("ventas.xlsx"), "ventas.xlsx")
const edited = await doconda.documents.create({
  operation: "edit",
  file: file.id,
  prompt: "Añade una columna Margen en la hoja Ventas: ingresos menos costes, y un total al final",
})
const report = await doconda.documents.report(edited.id)
for (const issue of report.issues) console.log(issue.code, issue.message, issue.location)
await writeFile("ventas-editado.xlsx", await doconda.documents.download(edited.id, "xlsx"))