import xlwt
wb
= xlwt
.Workbook
()
ws
= wb
.add_sheet
('成绩')
def excel():
a
= [[" ","成品","三级品","成品","三级品","成品","三级品","成品","三级品"],["一班","20","2","20","2","20","2","20","2"],
["二班","20","2","20","2","20","2","20","2"],["三班","20","2","20","2","20","2","20","2"],["四班","20","2","20","2","20","2","20","2"]]
for i
in range(len(a
)):
for j
in range(len(a
[0])):
ws
.write
(i
, j
,a
[i
][j
])
wb
.save
('peipeiii.xls')
excel
()
输出表格结果:
转载请注明原文地址:https://ipadbbs.8miu.com/read-24764.html