import xlwt
datalist = [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
workbook = xlwt.Workbook(encoding="utf-8") #创建workbook对象
worksheet = workbook.add_sheet('sheet1')
for i in range(0, 16):
data = datalist[i]
for j in range(0, 8):
worksheet.write(i , j, datalist[j])
workbook.save('test.xls')
请教:上面的代码存在什么问题?
import xlwt
datalist = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16]
workbook = xlwt.Workbook() # 创建workbook对象
worksheet = workbook.add_sheet('sheet1')
for i in range(0, 16):
worksheet.write(0, i, datalist[i])
workbook.save('test.xls')