sheet

Steps

1. harness_call {"operation":"document.list"}: reuse an open session. Otherwise call harness_call {"operation":"document.open","args":{"path":"<absolute path>"}}, or document.create with a new .xlsx path.
2. The outline lists # sheet <name>, then A1<TAB>value lines. Formulas appear as =SUM(B2:B3), followed by the cached value. A {…} tag shows the cell's format.
3. Edit with document.apply using sessionId and ops. Write a row or a block at a time.
4. Save with document.save.
5. To check how a sheet looks, call harness_call {"operation":"document.render","args":{"sessionId":"…"}}. It returns up to 4 sheets' used ranges as images, as the workbook is now (saved or not). When the reply has next, call again with its from until every sheet has been seen.

Ops

• {"op":"set_cell","sheet":"Sales","cell":"B4","value":"=SUM(B2:B3)"} writes a cell. A leading = makes a formula, and an empty string clears the cell. Numbers go as plain digits, for example 1250.
• {"op":"add_sheet","name":"Summary"}
• {"op":"set_format","target":"Sales!A1","format":{"bold":true,"align":"center","color":"#1c7ed6","size":12,"fill":"#ddebf7"}}. fill is the cell background.

Notes

• The cell keeps its number format (percent, thousands, dates) when only its value changes.
• Formulas compute as you write them: the outline shows each result in parentheses after the formula (=SUMIFS(…) (1500)), so check results there. A function the tab does not know keeps its formula text until Excel opens the file; the save stores computed values for the rest.
• On revision_conflict, call document.read and apply again.