JZTXT

openpyxl模块创建excel

发布时间 2024-01-10 10:14:21作者: 往事已成昨天
def new():
  from openpyxl import Workbook
  wb = Workbook()
  sh1 = wb.active
  sh2 = wb.create_sheet('数据')
  sh3 = wb.create_sheet('人员',0)
  wb.save('C:/Users/admin/Desktop/create.xlsx')
if __name__ == "__main__":
  new()
实现效果：