I recently started writing a small program for reading multiple xls files from one directory.
While reading one file like this,works perfectly:
wb = xlrd.open_workbook("C:\\path\\FileName.xls") sh = wb.sheet_by_index(0)
this one doesn't:
os.chdir("C:\\path") for fileName in os.listdir("."): wb = xlrd.open_workbook(fileName) sh = wb.sheet_by_index(0)
I keep getting the same error:
XLRDError: Expected BOF record; found 0x614d
I have no idea what I am doing wrong, please help.