代码片段一

  1. #!/usr/bin/env python
  2. # coding=utf-8
  4. from xlwt import *
  5. #需要xlwt库的支持
  6. #import xlwt
  7. file = Workbook(encoding = 'utf-8')
  8. #指定file以utf-8的格式打开
  9. table = file.add_sheet('data')
  10. #指定打开的文件名
  12. data = {
  13.         "1":["张三",150,120,100],
  14.         "2":["李四",90,99,95],
  15.         "3":["王五",60,66,68]
  16.         }
  17. #字典数据
  19. ldata = []
  20. num = [a for a in data]
  21. #for循环指定取出key值存入num中
  22. num.sort()
  23. #字典数据取出后无需，需要先排序
  25. for x in num:
  26. #for循环将data字典中的键和值分批的保存在ldata中
  27.     t = [int(x)]
  28.     for a in data[x]:
  29.         t.append(a)
  30.     ldata.append(t)
  31.     print(ldata)    
  33. for i,p in enumerate(ldata):
  34. #将数据写入文件,i是enumerate()函数返回的序号数
  35.     for j,q in enumerate(p):
  36.         # print i,j,q
  37.         table.write(i,j,q)
  38. file.save('data.xls')

代码片段二

  1. #coding:utf-8
  2. import requests
  3. from xlwt import *
  5. dicts = {'Alice': '2341', 'Beth': '9102', 'Cecil': '3258'}
  6. cookies = dicts
  7. r = requests.get('https://api.github.com/events',cookies=cookies)
  8. print(r.url)
  9. print(r.text)
  10. file = Workbook(encoding = 'utf-8')
  11. #指定file以utf-8的格式打开
  12. table = file.add_sheet('data')
  13. table.write(1,1,r.url)
  14. table.write(2,1,r.url)
  15. file.save('data_res.xls')