#coding=utf8
import xlwt
data = {"A":[(1,2,3),(4,5,6)],"B":[(7,8,9),(10,11,12)],"C":[(13,14,15),(16,17,18)],'D':[(19,20,21,22),(23,24,25,26),(27,28,29,30)]}
wb=xlwt.Workbook()
sheet_index=wb.add_sheet(u"目录")
sheet_index.write(0,0,u'用户编号')
index = 1
for k in data:
sheet_index.write(index,0,k)
index += 1
index = 0
for k in data:
sheet=wb.add_sheet("%s" % k)
sheet.write(0,0,u'名字')
for d in range(0,len(data[k][0])):
sheet.write(0,d + 1,u'数值'+str(d+1))
for d in range(0,len(data[k])):
sheet.write(d + 1,0,k)
for value_index in range(0,len(data[k][d])):
sheet.write(d + 1,value_index + 1,data[k][d][value_index])
wb.save("test.xls")