本帖最后由 suchocolate 于 2021-8-12 08:11 编辑 import requests
from bs4 import BeautifulSoup
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws['A1'] = "IP地址"
ws['B1'] = "总数"
n = 2
ips = ['192.168.3.12', '192.168.55.20', '192.168.3.18', '192.168.70.18', '192.168.3.15', '192.168.70.20',
'192.168.70.24']
urls = ["http://%s/web/guest/cn/websys/status/getUnificationCounter.cgi",
"http://%s/web/guest/cn/websys/status/configuration.cgi"]
for i in ips:
for url in urls:
req = requests.get(url % i)
html = req.text
bs = BeautifulSoup(html, "html.parser")
trs = bs.select('tr.staticProp')[1].get_text()
r = str(n)
n = n + 1
ws['a' + r] = i
ws['b' + r] = i
ws['c' + r] = trs[3:]
wb.save("C:\\New folder\\11.xlsx")
|