安装加载openpyxl模块:
cmd下运行:
pip install openxl
#__author__: zoe
#date: 2020/5/12
import openpyxl as x
wt = x.Workbook() ##Workbook() W要大写
ws = wt.active
ws[‘A1‘] = ‘姓名‘
ws[‘B1‘] = ‘年龄‘
ws[‘C1‘] = ‘学号‘
wt.save(‘E:\\openxls.xls‘)
#print(ws)
原文：https://www.cnblogs.com/zpzhou/p/12877624.html