Python win32com xls文件和xlsx文件格式互相转换
def xls_xlsx(path): # 格式转换 app = win32com.client.Dispatch('Excel.application') ao = app.Workbooks.Open(path) # 打开要转换的excel # 另存为新文件 new_excel_path = path.split(".")[:-1][0] + ".xlsx" print(new_excel_path) # ao.SaveAs(new_excel_path, FileFormat=51) # 另存为xls格式 # ao.Close() # app.Application.Quit() def xlsx_xls(path): # 格式转换 print(path) app = win32com.client.Dispatch('Excel.application') ao = app.Workbooks.Open(path) # 打开要转换的excel # # 另存为新文件 new_excel_path = path.split(".")[:-1][0] + ".xls" print(new_excel_path) ao.SaveAs(new_excel_path, FileFormat=56) # 另存为xls格式 ao.Close() app.Application.Quit() if __name__ == '__main__': print(os.getcwd()) # xls_xlsx(os.getcwd() +"\81导出.xls") xlsx_xls(os.getcwd() + "\81导出.xlsx")