error> cannot import name 'load_workbook' from partially initialized module 'openpyxl'

Asked Oct 11 '20 at 14:26

Active Oct 11 '20 at 14:26

Viewed 225 times

I am trying to do 'pd.read excel' but one file can be opened but newly imported file from other folder can not be opened with error like below. For reference, same format of excel file (xls)

Error message: xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'\xff\xfe\r\x00\n\x00\t\x00'

when I import openpyxl, error is like right below

Error message: ImportError: cannot import name 'load_workbook' from partially initialized module 'openpyxl'

For reference, openpyxl version 3.0.4

asked Oct 11 '20 at 14:26

forward 24

Looks like wrong version of excel. Save the excel file as `xlsx` and retry. – Mike67 Oct 11 '20 at 14:29
I tried but it was not working.. – forward 24 Oct 11 '20 at 22:36
Possible solutions here: https://stackoverflow.com/questions/9623029/python-xlrd-unsupported-format-or-corrupt-file – Mike67 Oct 11 '20 at 23:16

error> cannot import name 'load_workbook' from partially initialized module 'openpyxl'

0 Answers0