Pandas 0.22.0: Indexerror: List Index Out Of Range When Reading Xls

I'm trying to load a 282Mb (65536 rows x 138 columns) .xls file into a pandas dataframe import pandas as pd import os filename = r'invoicing.xls' dir = os.path.dirname(os.path.abs

Solution 1:

I was having the same issue. After i copied and pasted "values only" into a new sheet, move the sheet around (order of the sheet), it is working now. This is annoying.