python 将excel转换成字典，并且将字典写到txt文件里

# -*- coding: utf-8 -*-
#python2.7
import sys
reload(sys)
sys.setdefaultencoding('utf-8')

from pyexcel_xlsx import get_data
import json

alldata = []


def read_xlsx():
    data = get_data('yingji.xlsx',start_column=1)
    for i,k in data.items():# i:sheet名，k：每个sheet中的数据，列表
        print(k[2][0]) # 表头
        for d in k[3:]: # d：每行数据，列表
            if d:
                sub = {} #要写在文件中的字典
                for n in range(len(k[2])):#表头为key
                    try:
                        if d[n]:
                            sub[k[2][n]] = d[n]
                        else:
                            sub[k[2][n]] = ''
                    except:
                        sub[k[2][n]] = ''
                alldata.append(sub)
    ddd = json.dumps(alldata,indent=2,ensure_ascii=False)  #ensure_ascii=False ：防止将文字转成unicoe
    print(ddd)
    with open('emergency1.py','a+') as f:
        f.write(ddd)
read_xlsx()

 

转载于:https://www.cnblogs.com/wt11/p/7591760.html