034 批量新建并保存多个工作表

034 批量新建并保存多个工作表

import xlwings as xw

app = xw.App(visible=False, add_book=False)
for i in range(1, 5):
    wbs = app.books.add()  # 新建工作表
    wbs.save(f'D:\\python_file\\{i}.xlsx')
    wbs.close()
app.quit()