003

原始文件为 Python 代码，本文是转换后的 Markdown 文件。

import  json
from collections import  OrderedDict
import xlwt

# 2. Python 处理 JSON 文件
with open('source/students.txt',encoding='utf-8') as f:
    students_dict = json.load(f,object_pairs_hook=OrderedDict)
    print(students_dict)

# 3. Python String 转换为 Dict
import ast
dict_str = "{'test': 1}"
row = ast.literal_eval(dict_str)
print(row)

# 1. Python 与excel文件打交道
# 创建一个工作簿
wb = xlwt.Workbook()  
# 创建一个sheet
ws = wb.add_sheet('student') 

row = 0
for k,v in students_dict.items():
    ws.write(row,0,k)
    col = 1
    for item in v:
        ws.write(row,col,item)
        col += 1
    row +=1
wb.save('student.xls')  #保存