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

这篇文章主要介绍了Python实现将Excel转换为json的方法,涉及Python文件读写及格式转换相关操作技巧,分享给大家供大家参考，具体如下：

#-*- 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")

Excel文件

json