Working with Office documents

Oda builds and edits Word, Excel and PowerPoint files in your workspace, and can check a finished file before you open it. The check is structural, so it confirms the file's structure and text, not its appearance.

Build a document, presentation or workbook

  1. Ask in a chat and describe the result you want, including the layout; for example Build a Word report from this month's sales, with a summary table on page one. If the file should be built on your company's data, get the numbers first, as in Company data, documents and reports.
  2. Oda builds the file in your workspace. The layout and authoring rules come from the bundled Office skills that ship with Oda (Bundled skills). Each is a skill folder on your computer, like any other (Skill files and folders).
  3. When the file is ready, it appears as a file card: Preview in sidebar opens it in the side panel, and Open in Excel, or the file's own app, opens it there.
You ask forOda can make
A Word documentReports, letters and formatted tables (.docx)
A PowerPoint presentationSlides with text, tables, images and charts (.pptx)
An Excel workbookCell values, formulas and formatting (.xlsx)

How Oda checks a finished document

Oda can run a check on a finished file. The check is read-only, looks inside the file's structure, and gives a verdict of pass or fail (exit code 0 when everything passed, 1 when a check failed, and 2 when the check request itself was wrong).

It reports four checks:

The check is strict about what it accepts:

Important

A passing check says the structure and the text are in order. It does not judge pagination, clipping, fonts, chart appearance or how Excel recalculates values, and it does not evaluate formulas. Open the file to see the finished result.

The bundled runtime for document work

Document work runs on a bundled runtime, not on software already on your computer. Oda prepares its own copy of Python 3.9 or later with the libraries these skills need, and Node.js and pnpm when the app provides them. The preparation appears in the chat as Load workspace dependencies, and it returns the paths Oda will use. The first document task prepares the copy; later tasks reuse it.

Questions, answered

How do I get a file checked?

Ask in the chat, for example Check that the presentation has 12 slides or Check that the report contains the payment terms. Oda runs the check and tells you the verdict. If a check fails, ask Oda to fix the file and check it again.

Does a passing check mean the document looks right?

No. The check is structural: it does not judge pagination, clipping, fonts, chart appearance or how Excel recalculates values. Open the file to see the finished result.

Are Excel formulas calculated in the file Oda makes?

No. Oda writes the formula, but nothing calculates it until the workbook is opened in Excel. The check does not evaluate formulas, so a formula cell can look empty or stale in another tool until then.

Can Oda check an old .doc, .ppt or .xls file?

No. The check covers .docx, .pptx and .xlsx only, and legacy, encrypted and macro-enabled files need their own workflow. Renaming a file does not convert it.

Does the check change my file?

No. The check only reads the file. It never modifies the document it checks.

What does a failed check tell me?

It names the check that failed and what it found. Ask Oda to fix the file and run the check again.

Can Oda update a workbook that is open in Excel?

Close it first, or ask Oda to save a new copy. Excel locks an open workbook, so a save over the open file can fail.

Where does Oda keep the files it makes?

In your workspace, together with any scripts and working files it uses for the task.

Do I need to install Python or anything else?

No. Oda prepares and manages its own bundled copy, so nothing is installed into your own setup, and PATH is never changed.

What happens if the bundled runtime cannot be prepared?

Oda keeps serving the previous complete copy for one more task and retries on the next. If the copy cannot be used at all, Oda reports the reason instead of working around it.

Why does the check say my text is missing?

Text checks read the main part of the document, plus the headers, footers and notes it links to. Text in comments, in a glossary or in unreferenced parts of a Word file does not count, and in a presentation, chart text and speaker notes are not searched. Put the text in the document body or on a slide and check again.