fastexcel icon indicating copy to clipboard operation
fastexcel copied to clipboard

Strange failure to determine `string` dtype column in ODS sheet/file

Open alexander-beedie opened this issue 6 months ago • 2 comments

Attached two visually-identical files below that can be used to reproduce the issue. Both appear to contain identical column data, but one fails to load while the other succeeds.

Screenshot 2024-08-07 at 12 08 56

⬇️ success.ods ⬇️ failure.ods

Example:

import fastexcel as xl

xl.read_excel("success.ods").load_sheet(0)
# ExcelSheet<Test>

xl.read_excel("failure.ods").load_sheet(0)
# CannotRetrieveCellDataError: cannot retrieve cell data at (8, 0)
# Context:
#     0: could not determine dtype for column StringCol

alexander-beedie avatar Aug 07 '24 08:08 alexander-beedie