Python实现将Excel转换为json的方法示例

#-*- encoding:utf-8 -*-import sysimport localeimport os.pathimport osimport timeimport shutilimport datetimeimport typesimport 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")