BadZipfile: File is not a zip file on Windows not on Mac OS

[wjayne]

When trying to run code on my computer that my partner wrote on his computer, I get this error when I run

def read_excel(file):
    xl = pd.ExcelFile(file)
    df = xl.parse(0)
    return df

Here's the Error messages:
File "C:\Users\wjayn_000\Documents\GitHub\tippecanoe\app\views\lodging.py", line 19, in lodging_output
hotels = read_excel(f)
File "C:\Users\wjayn_000\Documents\GitHub\tippecanoe\app\views\functions.py", line 7, in read_excel
xl = pd.ExcelFile(file)
File "C:\Python27\lib\site-packages\pandas\io\excel.py", line 212, in init
self.book = xlrd.open_workbook(file_contents=data)
File "C:\Python27\lib\site-packages\xlrd__init__.py", line 399, in open_workbook
zf = zipfile.ZipFile(timemachine.BYTES_IO(file_contents))
File "C:\Python27\lib\zipfile.py", line 770, in init
self._RealGetContents()
File "C:\Python27\lib\zipfile.py", line 811, in _RealGetContents
raise BadZipfile, "File is not a zip file"

[jreback]

you can try to post this on xlrd, though it appears you have a corrupt file

[alfredrumss]

did you can resolve this problem ??

[ses4j]

Same happened to me -- Mac OS X dev committed a xlsx and pandas could not read it on my Windows box but it worked fine for the Mac guys.. Never fixed it. Excel could open it fine. I tried using Excel to re-save it, assuming git had corrupted line endings or something, but no change. Eventually, just used Excel to export as CSV and used read_csv instead.