开发环境:
Python版本:2.7.10
#coding=utf-8
import xlrd
from collections import OrderedDict
import json
import codecs
work_book = xlrd.open_workbook('test.xlsx')
sheet = work_book.sheet_by_index(0)
return_data = []
for i in range(0, row):
rowValues = sheet.row_values(i)
return_data.append(rowValues);
jd = json.dumps(return_data)
with codecs.open('file.json', 'w', 'utf-8') as f:
f.write(jd)
这里面直接按照一行的数据存储到List里面然后写入到Json 文件中