operation: "edit". Doconda changes only what you ask, leaves the rest of the sheet identical and writes the changes
as real formulas, not pre-computed numbers.
Steps
- Store your API key in
DOCONDA_API_KEYand install the SDK (pip install docondaornpm install @doconda/sdk). - Upload the Excel file with
files.upload. - Ask for the change, check the report and download the
.xlsx.
What you get back
- The same Excel file with the change made with formulas, and its PDF.
- A report: the result is reviewed as in Review. Formulas with errors (
#REF!,#DIV/0!…), broken references or a hand-typed number among identical formulas show up inissues, with the sheet and cells inlocation. status:ready,ready_with_warnings,needs_revieworfailed. If the request can’t be turned into changes,failedwithedit_not_understood, not charged.
Limits
.xlsis accepted: the result comes out as.xlsx.- With
quality: "fast"and with.xls, each change arrives as anedit.operation_appliedevent with the before and after, and is kept in the report (edits). - 50 pages maximum.
FAQ
Why not let the model rewrite the sheet?
Why not let the model rewrite the sheet?
A model tends to return pre-computed values: the sheet looks right but stops recalculating. With
edit the rest
stays identical and new content goes in as formulas.Can I just check an Excel file for errors?
Can I just check an Excel file for errors?
Yes, with
operation: "review", no AI. It detects formula errors, broken references, numbers stored as text and
hidden data, among others.What about a new Excel file with formulas?
What about a new Excel file with formulas?
Use
format: "xlsx" and a prompt. See Excel with formulas from an LLM.Keep reading
- Edit and Review.
- Quickstart.