calamine icon indicating copy to clipboard operation
calamine copied to clipboard

CalamineError: calamine error: Xlsx error: Expecting alphanumeric character, got 24

Open keyou666 opened this issue 1 year ago • 1 comments

I've been trying to read excel file using polars.read_excel, but came across a calamine error: Xlsx error, which states that Expecting alphanumeric character, got 24.

Is there any solution? Many thanks!


data = pl.read_excel(r'D:/MT_PAYDTL-NEW-20568-20241012041604.xlsx', engine='calamine', schema_overrides={"其他税前收入备注": pl.Utf8, "其他税前扣款备注": pl.Utf8, "其他税后扣款备注": pl.Utf8,  "其他税后收入备注": pl.Utf8, "特殊奖金备注": pl.Utf8 },infer_schema_length=None)

data = data.to_pandas()

data = data.where(pd.notnull(data), np.nan)

keyou666 avatar Oct 12 '24 11:10 keyou666

Could you share the workbook so we can inspect?

tafia avatar Oct 18 '24 13:10 tafia