16.python处理excel表格---1

安装加载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)