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")