自动化办公篇之python

1、如果没有安装xlwings库,先在控制台pip install xlwings,然后点击运行,创建四个空excel表 。

import xlwings as xw
app = xw.App(visible=True,add_book=False)
for dept in ["技术部","销售部","运营部","财务部"]:
    workbook=app.books.add()
    workbook.save(f"./部门业绩-{dept}.xlsx")

 ​​​​​