一、建立ECEXL
列入
73342cad-92ba-45a6-b08a-492f528c8e7a
086577dd-9d3a-4e83-a597-90a731932508
e7063493-b794-4613-b612-7f7e74e9aa78
6512b1dd-a424-4a4d-b910-19bf20e167ca
二、PYTHON代码
import requests
import json
import pandas as pd
import numpy as np
import xlrd
import sys
import pyzbar.pyzbar as pyzbar
if len(sys.argv) < 2: #调用时只使用一个参数命令
sys.exit(0) #无错退出
data = pd.read_excel(sys.argv[1])
train_data = np.array(data) # np.ndarray()
excel_list = train_data.tolist() # list
for i in excel_list:
print("正在查询", i[0])
payload = {"projectId": i[0]}
r = requests.get("http://hkrealestate.haikou.gov.cn/hkweb/project/queryHousesGroupByUnit?page=1&limit=1000000", params=payload,stream=True)
print(r.url)
res = r.json()
res1=res['data']
res2=res1['data']
df = pd.DataFrame(res2)
df.index
# 删除已有的result.xlsx
dir = "/.result.xlsx"
df.to_excel('result.xlsx', index=False, )
print('数据保存成功!')
三、运行只能保存最后一条记录
为啥只有读取保存最后一条6512b1dd-a424-4a4d-b910-19bf20e167ca