# 将.xlsx转换为.xls
from pathlib import Path
import xlwings as xw
app = xw.App(visible=False, add_book=False)
folder_path = Path('D:\\python_file\\')
file_list = folder_path.glob('*.xlsx') # 获取文件夹下所有'.xlsx'格式工作簿的文件路径
for i in file_list:
new_file_path = str(i.with_suffix('.xls')) # 构造转换文件格式后的完整文件路径
workbook = app.books.open(i)
workbook.api.SaveAs(new_file_path, FileFormat=56) # 将.xlsx to .xls 为56, 反之为51
workbook.close()
app.quit()
完成后如下截图所示