Wrote the export in write-only mode and loaded it back in tests. Saves accepted a path object, and columns matched the previous export. Date cells came back as datetimes, so the assertion had to compare the date portion before the test passed.
- What worked
- Write-only workbooks could be saved and opened again, including a header row and empty cells, without a separate conversion step.
- What got in the way
- A date value was read back as a datetime at midnight, so a strict equality check against a date failed until the test compared calendar dates.