Skip to content
agent-xlsx

Formats

agent-xlsx supports five spreadsheet formats across read, write, VBA, and screenshot operations.

SUPPORTED FORMATS

  • .xlsx (Excel 2007+) — read, write, screenshot
  • .xlsm (Excel Macro) — read, write, VBA, screenshot
  • .xlsb (Excel Binary) — read, VBA, screenshot
  • .xls (Excel 97-2003) — read, VBA, screenshot
  • .ods (OpenDocument) — read, screenshot

FORMAT NOTES

.xlsx (Excel 2007+)

The primary format. Full read and write support across all commands. This is the default output format for write operations.

.xlsm (Excel Macro-Enabled)

Identical to .xlsx but with VBA macro support. The vba command can list, read, and run macros in .xlsm files. Write operations preserve existing macros.

.xlsb (Excel Binary)

A binary format that is faster to load and smaller on disk than .xlsx. Read and screenshot operations work fully. VBA inspection is supported via oletools.

Write limitation: .xlsb files cannot be written to. Only .xlsx and .xlsm support write operations.

.xls (Excel 97-2003)

The legacy Excel format. Read and screenshot operations work fully. VBA inspection is supported via oletools.

Write limitation: .xls files cannot be written to. Only .xlsx and .xlsm support write operations.

.ods (OpenDocument Spreadsheet)

The open-source spreadsheet format used by LibreOffice and other applications. Read and screenshot operations work fully. VBA is not applicable to this format.

Write limitation: .ods files cannot be written to. Only .xlsx and .xlsm support write operations.

WRITE SUPPORT

Only .xlsx and .xlsm files support write operations. Attempting to write to .xlsb, .xls, or .ods files will fail — use read + export to extract data, then write to a new .xlsx file instead.

DATE HANDLING

agent-xlsx includes automatic date handling. Excel stores dates as serial numbers (e.g. 45658 for 2024-12-31) with a date number format. The Polars adapter (via fastexcel/calamine) detects these formats and parses date columns as ISO 8601 strings (YYYY-MM-DD or YYYY-MM-DDTHH:MM:SS) in the output.

Date handling is applied automatically across read, search, export, and probe commands. This is always-on best-effort — columns with date number formats are converted; those without (e.g. General format) are left as-is.