Error Trying To Read Blockede Xls File On Python

I am trying to open an Xls file on using python pandas ( also tried several others libraries like xlrd and pyexcel) and wasnt able to open it. when a try to used the comand df =

Solution 1:

I've noted that if you open and save the file you can read it. This piece of code solve the problem:

xcl = win32com.client.Dispatch('Excel.Application')
wb = xcl.workbooks.open(filename)
xcl.DisplayAlerts = False
wb.Save()
xcl.Quit()