xlsx and xlsm files return badzipfile: file is not a zip file

python python-2.7 openpyxl
zw1ck picture zw1ck · Nov 23, 2015 · Viewed 26.3k times · Source

I'm trying to open both an xlsx file and an xlsm file both give me the same error

badzipfile: file is not a zip file

here is what I'm typing:

import openpyxl
wb=openpyxl.load_workbook('c:\\users\\me\\documents\\filename.xlsm', keep_vba=True)
wb2=openpyxl.load_workbook('c:\\users\\me\\documents\\filename2.xlsx')

both load_workbook commands result in the same error. They both exist at that location. why am I getting this error?

Answer

user5449023 picture user5449023 · Jan 23, 2016

The same problem occurred to me, and then I noticed the following:

When I created the .xlsx file from file manager, by creating new document with .xlsx format, I had the same error. But when I created the file with some spreadsheet software (libreoffice-calc) in my case, it just worked fine. I hope this may help.

Related questions

How to upload a file to sharepoint site using python script

Is there a way to upload a file on sharepoint site using python script? I tried installing haufe.sharepoint, but it seems like it failed to fetch ntlm while it was installing, and I can't even use the connector module …

Read More
Openpyxl does not close Excel workbook in read only mode

I want to be able to read an Excel file in Python, keep the Python script running doing something else after the reading is finished, and be able to edit the Excel file in another process in the meantime. I'm …

Read More
ImportError: cannot import name get_column_letter

I am able to use openpyxl as an import in my code. But when I try to do the following: from openpyxl.cell import get_column_letter I get the following error: ImportError: cannot import name get_column_letter I …

Read More