读取xlsx保存到json
import sys reload(sys) sys.setdefaultencoding( "utf-8" ) 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('./test3.xlsx') sheet_name= workbook.sheet_n