如何使用 Python 写入 Excel 电子表格？

如何解决如何使用 python 写入 Excel 电子表格？？

import xlwt

def output(filename, sheet, list1, list2, x, y, z):
    book = xlwt.Workbook()
    sh = book.add_sheet(sheet)

    variables = [x, y, z]
    x_desc = 'display'
    y_desc = 'Dominance'
    z_desc = 'Test'
    desc = [x_desc, y_desc, z_desc]

    col1_name = 'Stimulus Time'
    col2_name = 'Reaction Time'

    #You may need to group the variables together
    #for n, (v_desc, v) in enumerate(zip(desc, variables)):
    for n, v_desc, v in enumerate(zip(desc, variables)):
        sh.write(n, 0, v_desc)
        sh.write(n, 1, v)

    n+=1

    sh.write(n, 0, col1_name)
    sh.write(n, 1, col2_name)

    for m, e1 in enumerate(list1, n+1):
        sh.write(m, 0, e1)

    for m, e2 in enumerate(list2, n+1):
        sh.write(m, 1, e2)

    book.save(filename)

更多解释： https ://github.com/python-excel

解决方法

import xlwt

x=1
y=2
z=3

list1=[2.34,4.346,4.234]

book = xlwt.Workbook(encoding="utf-8")

sheet1 = book.add_sheet("Sheet 1")

sheet1.write(0,"Display")
sheet1.write(1,"Dominance")
sheet1.write(2,"Test")

sheet1.write(0,1,x)
sheet1.write(1,y)
sheet1.write(2,z)

sheet1.write(4,"Stimulus Time")
sheet1.write(4,"Reaction Time")

i=4

for n in list1:
    i = i+1
    sheet1.write(i,n)

book.save("trial.xls")

大盘站长永久会员

打赏 收藏 海报 链接