python xlsxwriter 写e

发布时间：2019-09-02 07:46:23编辑：auto阅读（1948）

    代码：

    # -*- coding:utf-8 -*-
    __author__='comk'
    import xlsxwriter
    data_dict={
                        "1":[u"张三",150,120,100],
                        "2":[u"李四",90,99,95],
                        "3":[u"王五",60,66,68]
                }

    L = ["A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L","M", "N", "O", "P", "Q", "R", "S", "T", "U",\
             "V", "W", "X", "Y", "Z"]
    # 创建文件和表
    workbook = xlsxwriter.Workbook('demo.xlsx')
    worksheet = workbook.add_worksheet(    'student')
    # 表格列宽
    worksheet.set_column('A:A', 20)
    # 写数据
    n = 1
    for key,value in data_dict.items():
        x =     "A" + str(n)
        worksheet.write(x, key)
            for y in value:
            x = L[    int(value.index(y)) + 1] + str(key)
            worksheet.write(x, y)
        n +=     1
    workbook.close()


    效果图：

    wKiom1jI3_DDLSyPAAAZaT2HeL8322.png-wh_50

关键字：

上一篇： python-django-apache

下一篇： centos7 安装python3.6及