python批量查询IP物理地址输出到Exel

最新推荐文章于 2024-03-12 22:51:50 发布

SheepLeeeee

最新推荐文章于 2024-03-12 22:51:50 发布

阅读量1.2k

点赞数 2

文章标签： python 开发语言 http

本文链接：https://blog.csdn.net/m0_68074153/article/details/125999548

版权

requests模块发包

url="https://pdf-lib.org/tools/ip"
header = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36',
}
exel_ip = []
exel_add = []
with open("待查询ip.txt","r") as IP:
    for ip in IP:
        #ip="121.231.11.12"
        add={"IP":ip.strip()}
        res = requests.get(url=url,headers = header,params=add)
        ans_ip=re.findall("\"IPAddr\":\"(.+?)\",",res.text)
        exel_ip.append(ans_ip[0])
        ans_add= re.findall("\"CustomerAddress\":\"(.+?)\"", res.text)
        exel_add.append(ans_add[0])

将需要查询的IP传入到IP查询的url，正则匹配返回包内容提取查询结果存入列表。

xlwt模块写入Exel

book = xlwt.Workbook(encoding='utf-8',style_compression=0) #打开文件
sheet = book.add_sheet('ip归属地查询',cell_overwrite_ok=True) #创建一个sheet表格
col = ("ip","归属地") #定义列属性
for i in range(2):
    sheet.write(0,i,col[i])
for i in range(len(exel_ip)):	#结果列表写入文件
    sheet.write(i+1,0,exel_ip[i])
    sheet.write(i+1,1,exel_add[i])
savepath = 'ip归属地查询.xls'
book.save(savepath)

主要用到write方法，第一个参数为写入的行数，第二个参数为写入的列数，第三个参数为写入的值。

完整代码

import re
import requests
import xlwt

url="https://pdf-lib.org/tools/ip"
header = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36',
}
exel_ip = []
exel_add = []
with open("待查询ip.txt","r") as IP:
    for ip in IP:
        #ip="121.231.11.12"
        add={"IP":ip.strip()}
        res = requests.get(url=url,headers = header,params=add)
        ans_ip=re.findall("\"IPAddr\":\"(.+?)\",",res.text)
        exel_ip.append(ans_ip[0])
        ans_add= re.findall("\"CustomerAddress\":\"(.+?)\"", res.text)
        exel_add.append(ans_add[0])
print(exel_ip)
print(exel_add)
book = xlwt.Workbook(encoding='utf-8',style_compression=0)
sheet = book.add_sheet('ip归属地查询',cell_overwrite_ok=True)
col = ("ip","归属地")
for i in range(2):
    sheet.write(0,i,col[i])
for i in range(len(exel_ip)):
    sheet.write(i+1,0,exel_ip[i])
    sheet.write(i+1,1,exel_add[i])
savepath = 'ip归属地查询.xls'
book.save(savepath)