calamine
calamine copied to clipboard
CalamineError: calamine error: Xlsx error: Expecting alphanumeric character, got 24
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)
Could you share the workbook so we can inspect?