两行代码写Excel文件:
import json
import pandas as pd
# read_json第一个参数是一个路径或者json数组字符串,所以如果是一个数组的话,要转换成字符串
df = pd.read_json(json.dumps(jsonobj), orient='records')
# 写Excel,filename是文件路径,columns是表头,字段对应上面的数组对象
df.to_excel(filename, index=False, columns=["id","price","name","size","year","hour","area","date","weight","deep","rpm","length"])