python 写入Excel文件

直接上代码：

# -*- coding: utf-8 -*-
import json
import xlwt
import datetime
import traceback
import sys
reload(sys)
sys.setdefaultencoding( "utf-8" )


class QueryFromMysqlToExcelManage(object):
    # 导出excel/csv
    def ip_manage(self, datas):
        try:
            wb = xlwt.Workbook(encoding="utf-8")
            ws = wb.add_sheet(u"Excel Name", cell_overwrite_ok=True)
            #
            ws.write(0, 0, u"第一列")
            ws.write(0, 1, u"第二列")

            ws.col(1).width = 5000
            ws.col(2).width = 5000
            ws.col(0).width = 5000

            n = 0
            for data in datas:
                res = data.split(":")
                query = res[1]
                pre_query = res[0]
                row = [pre_query, query]
                n = n + 1
                for i in range(len(row)):
                    ws.write(n, i, row[i])
            wb.save("Excel_导出({}).xls".format(datetime.datetime.now().strftime("%m%d%H%M")))
        except Exception:
            traceback.print_exc()


if __name__ == "__main__":
    # 读取json写入excel
    json_file = "query_set_from_jira_temp.json"  # 改成你的路径
    datas = json.load(open(json_file, 'r'))

    temp = QueryFromMysqlToExcelManage()
    temp.ip_manage(datas)

程序中读取的json文件内容：

["女神:saggitarxm"]

生成的Excel效果：