xls格式转换为xlsx格式
import win32com.client as win32
fname = "C:\\myProjects\\daily\\data\\20171229\\标准化文档-20171226\\全量数据过滤表清单.xls"
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(fname)
wb.SaveAs(fname+"x", FileFormat = 51) #FileFormat = 51 is for .xlsx extension
wb.Close() #FileFormat = 56 is for .xls extension
excel.Application.Quit()
浙公网安备 33010602011771号