BUG: read_excel fuction return "zipfile.BadZipFile: File is not a zip file"

[dogeCoinMasterCoin]

Pandas version checks

• I have checked that this issue has not already been reported.

• I have confirmed this bug exists on the latest version of pandas.

• I have confirmed this bug exists on the main branch of pandas.

Reproducible Example

df = pd.read_excel(excel_file_path, sheet_name=sheet_name, engine='openpyxl')

Issue Description

Problem is a little bit odd due to a problem related only to an excel. I try to read some data from an excel, the code works perfectly fine with an excel created by me. I have an excel from PTC tool and with that excel when i try to read from it i get this error:

raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file

Did somebody know what problem can have an excel to raise this error? I can't put that excel here due to privacy policies, but it's not a complex one, actually have only some pivoted rows and tables, no functions behind or something else. Maybe one more thing to be mentioned, this excel was set to confidential as security manager , but i tried to remove that attribute and I've got the same error.

Expected Behavior

Read from that excel

Installed Versions

Python - 3.6.4 Office package - 2021

[fletcherjacob]

I have come across this issue before with Microsoft and it's due to the sensitivity tag on the document. The tag has the file encrypted which prevents it from being read correctly. The Microsoft's sensitivity tag can only be removed by the owner who placed it, or your orgs administrator. Some orgs. will have that label automatically applied.

[dogeCoinMasterCoin]

@fletcherjacob can you tell me where should I find those tags please? I think it is a place where are all displayed or something like that

[fletcherjacob]

If the confidential label/tag is enabled, the document owner or the person to set it will have to remove it. Some organizations have this enabled by default and only a permission admin can remove it from the file.
Are you able to remove the Sensitivity Label via the Excel application? If yes, are you still experiencing the error? If you create an Excel file and apply the sensitivity label, Do you still experience the issue?

Regarding Microsoft Sensitivity Labels:
https://learn.microsoft.com/en-us/purview/sensitivity-labels

[mroeschke]

Seems like this isn't a pandas specific issue so closing

[kelemul]

I tried every possibility. but, I found the problem is the URL. especially, if you are using an Excel file from the GitHub repository, you need to copy the raw file URL. do not use the URL copied from URL bar.

[fletcherjacob]

@kelemul that's awesome to hear! Thank you for commenting a update on your solution.

[mmorley0395]

Having this same issue. We are not using sensitivity labels, they're turned off on our tenant, so not sure why this is happening.