代码:
# -*- coding:utf-8 -*-
__author__='comk'
import xlsxwriter
data_dict={
"1":[u"张三",150,120,100],
"2":[u"李四",90,99,95],
"3":[u"王五",60,66,68]
}
L = ["A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L","M", "N", "O", "P", "Q", "R", "S", "T", "U",\
"V", "W", "X", "Y", "Z"]
# 创建文件和表
workbook = xlsxwriter.Workbook('demo.xlsx')
worksheet = workbook.add_worksheet('student')
# 表格列宽
worksheet.set_column('A:A', 20)
# 写数据
n = 1
for key,value in data_dict.items():
x = "A" + str(n)
worksheet.write(x, key)
for y in value:
x = L[int(value.index(y)) + 1] + str(key)
worksheet.write(x, y)
n += 1
workbook.close()
效果图:
转载于:https://blog.51cto.com/jingkonglanxing/1906837