Fixture Design¶
Fixtures are Excel-authored source files used as ground truth.
Principles¶
- Prefer real Excel-generated files for oracle behavior.
- Keep fixtures small, focused, and feature-specific.
- Store canonical fixtures in version control.
- Separate ephemeral benchmark output from canonical fixtures.
In the ExcelBench repository¶
Fixtures live in the ExcelBench repository:
- Canonical xlsx fixtures:
fixtures/excel/ - Canonical xls fixtures:
fixtures/excel_xls/ - Throughput fixtures:
fixtures/throughput_xlsx/
Regeneration¶
From the ExcelBench repo root:
uv run excelbench generate --output fixtures/excel
uv run excelbench generate-xls --output fixtures/excel_xls
These commands require Excel for fixture generation steps that rely on xlwings/Excel behavior.