Getting error while loading excel(.xlsx) file using openpyxl module

[shubhamjainj]

Hi,

1 2 3 4 5 6

import openpyxl #Path of workBook path = "C:\\***\\python_sheet.xlsx"   #Load worksheet from the directory(path) wb = openpyxl.load_workbook(path)

Getting following error while loading excel file from directory, even though excel it is not a zip file
[Error :]
raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file

How do we solve this problem

[buran]

even though excel it is not a zip file

you would be surprised to learn that new excel format i.e. xlsx, xlsm, etc... are indeed zip