python 保存xls文件

python 保存xls文件

代码

import xlwt                         #进行excel操作

#保存数据xls
def saveData(datalist,savepath):
    book = xlwt.Workbook(encoding = "utf-8",style_compression=0)
    sheet = book.add_sheet('test', cell_overwrite_ok=True)

    col = ["学号", "姓名", "班级", "专业"]   #列名
    for i in range(0, len(col)):
        sheet.write(0, i, col[i])

    for i in range(len(datalist)):
        data = datalist[i]
        for j in range(0, len(col)):
            sheet.write(i + 1, j, data[j])  # 写入一行数据
    book.save(savepath)  # 保存

if __name__ == "__main__":
    # 保存数据
    datalist = [["001", "小明", "1班", "软件工程"],
                ["002", "小红", "1班", "软件工程"],
                ["003", "小东", "2班", "网络工程"],
                ["004", "小华", "2班", "网络工程"],
                ["005", "小芳", "3班", "计算机科学与技术"],
                ["006", "小莉", "3班", "计算机科学与技术"],]
    # 保存路径
    savepath = "data.xls"
    # 调用方法
    saveData(datalist, savepath)

运行效果