import win32com.clientas win32
import os
import os.path
rootdir =u"C:\\Users\\86182\\Desktop\\files"
for parent, dirnames, filenamesin os.walk(rootdir):
for fnin filenames:
print(parent, fn)
filedir = os.path.join(parent, fn)
print(filedir)
excel = win32.DispatchEx('Excel.Application')
wb = excel.Workbooks.Open(filedir)
wb.SaveAs(filedir.replace('xls', 'xlsx').replace('XLS', 'xlsx'), FileFormat=51)
wb.Close()
excel.Application.Quit()
