Python批量将xls格式转换为xlsx格式，使用下面代码即可
- import win32com.client as win32
- fname = r'excelname.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()
-
湘公网安备 43102202000103号
