读取14000条字典数据写入Excel

# -*- coding:utf-8 -*-
#该文件是shuju  python文件
a=[{"name":"马攀","company":"广州市金鑫宝电子有限公司","address":"湖北省武汉市芳草路观澜御苑","mobile":"13178067042","number":"42923792.46","type":1},{"name":"范存衍","company":"杭州古力园林机械有限公司","address":"香港特别行政区雲景道50號富麗園","mobile":"14343228329","number":"91549291.89","type":1},{"name":"周戍泰","company":"重庆市永川区鸿运洗选厂","address":"四川省成都市青城山路青城溪谷","mobile":"16127326931","number":"33226909.69","type":1},{"name":"许泽琰","company":"中国建设银行股份有限公司南通市中华园分理处","address":"广西壮族自治区南宁市银沙大道11号新加坡城西区","mobile":"19455903278","number":"68907930.19","type":1},{"name":"任子斌","company":"四川金灿光电有限责任公司","address":"河北省沧州市光明街10号沧州市老电厂宿舍西院","mobile":"13472581781","number":"77032802.65","type":1},{"name":"廉诚","company":"铜陵三极照明科技有限责任公司","address":"上海市杨南路1139弄都林嘉苑北园","mobile":"14964108562","number":"24168753.94","type":1}]
#a是字典
import requests
print(a[1])

print(len(a))
b=a[1]
print(b)
print(type(b))
print(b.values())
c=list(b.values())
print(type(c))
print(c)
print(c[1])



# -*- coding: utf-8 -*-
import geohash as geohash
import xlwt  # 写入excel文件的库
# import xlrd  #读取Excel
import shuju
import  time
import  datetime
import geohash  #把经纬度转换为geohash



def xieru(c,hang,mySheet2): #写入第几行C的数值
     lie=0
     for i in range(len(c)):
         mySheet2.write(hang, lie, c[i])
         lie+=1
if __name__ == '__main__':
    start_time = datetime.datetime.now()
    myWorkbook2 = xlwt.Workbook()  # 创建Excel工作表
    mySheet2 = myWorkbook2.add_sheet('Test_Sheet')
    a=shuju.a
    hang=0   #从第0行开始写
    for b in a:
        c = list(b.values())
        xieru(c,hang,mySheet2)
        hang+=1
        if hang%200==0:
            print("已经写入完成第"+str(hang)+"行")
            myWorkbook2.save('test.xls')
    end_time = datetime.datetime.now()
    speed = end_time - start_time
    print('一共用时:' + str(speed))`