[已解决]怎么把带字典的列表写入excel

937135952

res = [{"city":"重庆"，"people":"10万"},{"city":"北京"，"people":"20万"},{"city":"上海"，"people":"30万"}]

1. 
   
2. 
   
3.     wb = openpyxl.Workbook()  
   
4.     ws = wb.active  
   
5.     ws['A1']="城市"
   
6.     ws['B1']="人口"
   
7.      
   
8.     for each in results:  
   
9.         ws.append(each)      
   
10.     wb.save("城市人口情况.xlsx")   

复制代码

比如上述情况，怎么才能写入excel呢，我知道如果each是一个列表的话，按这种方法就可以直接写入，但是是字典的话不知道要怎么做，还有[{"city":"重庆"，"people":"10万"},{"city":"北京"，"people":"20万"},{"city":"上海"，"people":"30万"}]这个东西应该怎么叫，字典列表？

最佳答案

月排行榜 / 总排行榜

suchocolate

2021-9-7 16:07:03

1. wb = openpyxl.Workbook()
   
2. ws = wb.active
   
3. ws['A1'] = "城市"
   
4. ws['B1'] = "人口"
   
5. 
   
6. res = [{"city": "重庆", "people": "10万"}, {"city": "北京", "people": "20万"}, {"city": "上海", "people": "30万"}]
   
7. for each in res:
   
8.     w = [each['city'], each['people']]
   
9.     ws.append(w)
   
10. wb.save("城市人口情况.xlsx")
    

复制代码

跳转到最佳答案楼层

suchocolate

1. wb = openpyxl.Workbook()
   
2. ws = wb.active
   
3. ws['A1'] = "城市"
   
4. ws['B1'] = "人口"
   
5. 
   
6. res = [{"city": "重庆", "people": "10万"}, {"city": "北京", "people": "20万"}, {"city": "上海", "people": "30万"}]
   
7. for each in res:
   
8.     w = [each['city'], each['people']]
   
9.     ws.append(w)
   
10. wb.save("城市人口情况.xlsx")
    

复制代码