I am using the following Python code in a bigger script, but when some excel files (.xls) are corrupt I get the following error:
raise XLRDError('Unsupported format, or corrupt file: ' + msg)
XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'X\xcf\x13\xe0\xa1\xb9\x1a\xe1'
It fails when opening a workbook that is corrupt (wb = xlrd.open_workbook(filepat
h)), which ends the script. Is there a way I can modify the script to bypass the corrupt excel file or move it somewhere else and allow the script to move on?
import pandas as pd
from os import path
for subdir, dirs, files in os.walk(r'C:\Temp'):
for file in files:
filepath = subdir + os.sep + file
wb = xlrd.open_workbook(filepath)