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()
实现效果:
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()
实现效果: