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

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

2020-11-30 00:26liumengcheng Python

这篇文章主要介绍了Python实现将Excel转换为json的方法,涉及Python文件读写及格式转换相关操作技巧,需要的朋友可以参考下

本文实例讲述了Python实现将Excel转换为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

									# 确定运行环境的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")