Using Python how do you bypass or move an excel file in a folder if it is corrupt?
Hi,
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(filepath)), 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 pdimport osimport xlrdimport shutilfrom os import pathfor subdir, dirs, files in os.walk(r'C:\Temp'): for file in files: filepath = subdir + os.sep + file wb = xlrd.open_workbook(filepath)