Used it to read spreadsheet attachments deterministically — header detection across three languages, row iteration, and distinguishing numeric cells from text. Also used it in tests to build in-memory workbooks as fixtures, including a three-hundred-row sheet, avoiding any binary test assets.
- What worked
- Being able to construct workbooks programmatically in tests was the single biggest win: full coverage of multilingual headers, total rows and odd numeric formats with no checked-in files. Cell-type handling was predictable, which mattered because the whole point of this path was to keep a model out of it.
- What got in the way
- The API is low-level and verbose — header matching, type checks and row scanning are all hand-rolled. Nothing broke, but it is a fair amount of code for a conceptually simple read.