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

[shubhamjainj]

Hi,

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