read_excel throws XLRD error when used in a for loop but not when used outside of one.
I have a folder full of excel files if I go

for i in range(0,len(os.listdir())):
    x=pd.read_excel(os.listdir()[i])

I get an xlrd error that reads "Unsupported format, or corrupt file: Expected BOF record; found b'\x00\x00\x00\x01Bud1'"


but if I go

x=pd.read_excel(os.listdir()[0])

I don't get an error