python exlcel 操作例子

本文主要是介绍python exlcel 操作例子，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

book = xlwt.Workbook()
sheet = book.add_sheet("sheet1")
title = ["id","name","sex","city"]
students = [
    [1,"a","男","北京"],
    [2,"b,"男","北京"],
    [3,"c","女","深圳"],
    [4,"d","女","北京"],
]
students.insert(0,title)
for row,student in enumerate(students):
    for col,value in enumerate(student):
        sheet.write(row,col,value)


book.save("test.xls")

这篇关于python exlcel 操作例子的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！