1、如果没有安装xlwings库,先在控制台pip install xlwings,然后点击运行,创建四个空excel表。
import xlwings as xwapp = xw.App(visible=True,add_book=False)for dept in ["技术部","销售部","运营部","财务部"]:workbook=app.books.add()workbook.save(f"./部门业绩-{dept}.xlsx")
1、如果没有安装xlwings库,先在控制台pip install xlwings,然后点击运行,创建四个空excel表。
import xlwings as xwapp = xw.App(visible=True,add_book=False)for dept in ["技术部","销售部","运营部","财务部"]:workbook=app.books.add()workbook.save(f"./部门业绩-{dept}.xlsx")