I am downloading a file using python and read it. But while reading the xls file it throws xlrd.biffh.XLRDError: Workbook is encrypted I am able to open the file manually but not in python

My code

df = pd.read_excel(filepath)

Can somebody help me on this! . I have researched a lot to crack this issue but None worked.

CodePudding user response：

XLRD is not capable of handling file with encryption on it's own, but there is another Python library that actually can unencrypt a lot of MS Office files including the one you are trying to read .xls. It's called msoffcrypto-tool