python语言xlrd -- excel转json

import xlrd
import json
import sys

#读取Excel文件的sheet1
sheet = xlrd.open_workbook("data.xls").sheets()[0]
#按行读取
rows = sheet.nrows
#保存关键字
keys = []
#保存结果
result = []

for i in range(rows):
    if i == 0:
        keys = sheet.row_values(i)#保存关键字
    else:
        record = {}
        cnt = 0
        # 将Excel文件的数据存入字典中
        for item in sheet.row_values(i):
            record[keys[cnt]] = item
            cnt += 1
        # 将字典存入列表
        result.append(record)

# 重定向并输出json文件
with open("标识线.json", "w+") as outputFile:
    sys.stdout = outputFile
    print(json.dumps(result, indent=4))