python实现Excel转json

来源：互联网发布：淘宝金币不够用怎么办编辑：程序博客网时间：2024/06/05 10:22
#-*- encoding:utf-8 -*-import sysimport localeimport os.pathimport osimport timeimport shutilimport datetimeimport types import sqlite3import pypyodbcimport tracebackimport jsonimport codecsimport xlrdimport xlwtfrom xlutils.copy import copy# 确定运行环境的encoding__g_codeset = sys.getdefaultencoding()if "ascii"==__g_codeset:    __g_codeset = locale.getdefaultlocale()[1]#def object2double(obj):    if(obj==None or obj==""):        return 0    else:        return float(obj)    #end if    #def utf8_to_mbs(s):    return s.decode("utf-8").encode(__g_codeset)#def mbs_to_utf8(s):    return s.decode(__g_codeset).encode("utf-8")#def _tongjiFirstRow():    #xlrd.Book.encoding = "gbk"    data = xlrd.open_workbook("xy.xls",formatting_info=True)    tblTDLYMJANQSXZB = data.sheets()[0]    #找到有几列几列    nrows = tblTDLYMJANQSXZB.nrows #行数    ncols = tblTDLYMJANQSXZB.ncols #列数    totalArray=[]    arr=[]    for i in range(0,ncols):       arr.append(tblTDLYMJANQSXZB.cell(0,i).value);    #end for       for rowindex in range(1,nrows):       dic={}       for colindex in range(0,ncols):          s=tblTDLYMJANQSXZB.cell(rowindex,colindex).value          dic[arr[colindex]]=s       #end for           totalArray.append(dic);    #end for          a=json.dumps(totalArray,ensure_ascii=False)    file=codecs.open("xy.txt","w",'utf-8')    file.write(a)    file.close()#end_tongjiFirstRow();print("export OK")
Excel文件
json
0 0