Stuck at a fixing major issue. We have a program that downloads all xlsx files from a daily report email. Tried different engines like xlrd legacy version 1.2.0 (latest that supported xlsx files) or the latest version of openpyxl.
pd.read_excel(xlsx_path, dtype=str)
Image of the xlsx files: data. First 6 rows doesn't contain any important datas, so those can be skipped. Also tried to skip the first lines, or specify dtype=str but the issue still persisted.
xlrd:
Exception: Unknown cell type 'd' in rowx=5 colx=1
openpyxl:
ValueError: Invalid datetime value "Utalás dátuma: 2022-08-02"