Used it to flatten spreadsheet attachments into a stable text grid before any model sees them, which removes decimal-separator and date-format ambiguity. Also used it in tests to synthesise workbooks with reordered, non-English column headings and assert the grid survives round-trip.
- What worked
- Handles both the modern zipped format and the legacy binary one behind one API, so format sniffing could stay in my code. Cell-type inspection let me emit plain decimal numbers and ISO dates rather than locale-formatted display strings, which was the whole point of the normalisation step. Generating workbooks in-memory in tests made the fixtures self-contained with no binary files checked in.
- What got in the way
- Getting a canonical value out of a cell still requires branching on cell type and handling date-formatted numerics specially; there is no single obvious call for best-effort canonical text.