python xlwt模块如何把列表写入Excel

Question

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')

请教：上面的代码存在什么问题？

Answer 1

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')

你只有一个列表，只要循环一次就够了，不需要循环两次