python打开xls,将内容保存至json--使用Python3会避免很多中文的问题

import json  
 
d = {"id": 1, "position": 3, "check_name": 2, "check_nums": 0}
 
with open("test.json", "w") as f:
    json.dump(d, f)

from xlrd import open_workbook
import xlwt

workbook = open_workbook('./test1.xls')
sheet_name= workbook.sheet_names()
sheet = workbook.sheet_by_index(0)
print(sheet.name, sheet.nrows, sheet.ncols)
print(sheet.cell(0,0))
print(sheet.cell_value(0,0))
print(sheet.cell_value(0,1))
print(sheet.cell_value(0,2))
savedata = []
for key in range(sheet.nrows):
    json_jpg={}
    json_jpg["id"] = sheet.cell_value(key,0)
    json_jpg["position"] = sheet.cell_value(key,1)
    json_jpg["check_name"] = sheet.cell_value(key,2)
    json_jpg["check_nums"] = 0
    savedata.append(json_jpg)

with open("./saved.json", 'w') as filejson:
    for tempjson in savedata:
        json_str = json.dumps(tempjson, ensure_ascii=False)
        filejson.write(json_str)
        filejson.write('\n')