Python實(shí)現(xiàn)將Excel轉(zhuǎn)換為json的方法示例

更新時(shí)間：2017年08月05日 11:34:35 作者：liumengcheng

這篇文章主要介紹了Python實(shí)現(xiàn)將Excel轉(zhuǎn)換為json的方法,涉及Python文件讀寫(xiě)及格式轉(zhuǎn)換相關(guān)操作技巧,需要的朋友可以參考下

本文實(shí)例講述了Python實(shí)現(xiàn)將Excel轉(zhuǎn)換為json的方法。分享給大家供大家參考，具體如下：

#-*- encoding:utf-8 -*-
import sys
import locale
import os.path
import os
import time
import shutil
import datetime
import types
import sqlite3
import pypyodbc
import traceback
import json
import codecs
import xlrd
import xlwt
from xlutils.copy import copy
# 確定運(yùn)行環(huán)境的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 #行數(shù)
  ncols = tblTDLYMJANQSXZB.ncols #列數(shù)
  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文件