Panic when converting a xls file to arrow

[stanoarn]

This xls file causes a panic when converting to arrow. The following invocation

RUST_BACKTRACE=1 python -c 'import fastexcel; import pyarrow; print(f"{fastexcel.__version__=}, {pyarrow.__version__=}"); reader = fastexcel.read_excel("./data/CRD_2019_V2_EN.xls"); reader.load_sheet(0).to_arrow()'

produces the errors in the attached file.

err.txt

The versions of involved packages are fastexcel.__version__='0.13.0', pyarrow.__version__='19.0.1'.

I suspect that the file might be malformed somehow, because when I try to read the file with xlrd, it produces the following warning:

WARNING *** OLE2 stream 'SSCS': expected size 1976448, actual size 512

[lukapeschke]

Thanks for the bug report! Indeed, the file is probably malformed, but a panic is still something we don't want (even though in this case, the cause probably stems from arrow). As a workaround, you can skip the first rows:

reader = fastexcel.read_excel("./data/CRD_2019_V2_EN.xls")
reader.load_sheet(0, skip_rows=7).to_arrow()

I'll look into this when I have a moment