Python将excel文件从xls转换为xlsx

赵乾舟

1. import win32com.client as win32
   
2. 
   
3. fname = "C:\\清单.xls"
   
4. excel = win32.gencache.EnsureDispatch('Excel.Application')
   
5. wb = excel.Workbooks.Open(fname)
   
6. 
   
7. wb.SaveAs(fname+"x", FileFormat = 51)    #FileFormat = 51 is for .xlsx extension
   
8. wb.Close()                               #FileFormat = 56 is for .xls extension
   
9. excel.Application.Quit()
   

复制代码