国产黄色av网站,91午夜伦伦电影理论片,免费成人高清在线视频

python 版本：2.7

只是讀取excel的話可以直接使用xlrd

代碼如下

									# -*-coding:utf8 -*-

									import xlrd

									from collections import OrderedDict

									import json

									import codecs

									file_name=raw_input('請輸入要轉換的excle文件路徑:')

									wb = xlrd.open_workbook(file_name)

									dict_list = []

									sh = wb.sheet_by_index(0)

									title = sh.row_values(0)

									for rownum in range(1, sh.nrows):

									 rowvalue = sh.row_values(rownum)

									 single = OrderedDict()

									 for colnum in range(0, len(rowvalue)):

									  print(title[colnum], rowvalue[colnum])

									  single[title[colnum]] = rowvalue[colnum]

									 dict_list.append(single)

									j = json.dumps(dict_list)

									with codecs.open(file_name[:-5]'.json',"w","utf-8") as f:

									 f.write(j)

2、json to excle

代碼如下

注意：標題會寫在最后一行，主要針對字段不同的json數據。

									import json

									import os

									from openpyxl import Workbook

									wb = Workbook()

									ws = wb.active

									cols = []

									def json2excel(jsfile, excfile):

									# 讀取json數據

									a = 1

									if os.path.exists(jsfile):

									with open(jsfile, 'r') as fp:

									while True:

									line = fp.readline()

									if not line:

									break

									jsdata = json.loads(line)

									for k in jsdata.keys():

									if k not in cols:

									cols.append(k)

									rowdata = []

									for col in cols:

									rowdata.append(jsdata.get(col))

									print '正在寫入的行數：'a

									ws.append(rowdata) # 寫行

									a += 1

									ws.append(cols) # 標題

									print('保存中')

									wb.save(excfile) # 保存

									if __name__ == '__main__':

									import sys

									if len(sys.argv) == 3:

									jsfile = sys.argv[1]

									excfile = sys.argv[2]

									json2excel(jsfile, excfile)

									else:

									print("Usage: python writeExc.py xx.json xx.xlsx")