今天老板给了个表要求去内网网页查询表中每个人的wifi是否有申请,由于是爬取内网网址,且无需登录即可查询,发现可以用python一键查询判断
一、导入需要用的包
import requests
import xlrd
import xlwt
二、代码主体
url1 = 'http://112.efoxconn.com/Home/FormInfo?staffno='
url2 = '&sonbr=&mobileno=&rnd=0.6021491592120509'
data = xlrd.open_workbook(r"C:\Users\Administrator\Desktop\TSBG人员WiFi账户统计_20201201.xlsx.xlsx") #读取表格数据
table = data.sheets()[0]
row = table.nrows
workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('sheet')
y=0
for i in range(1,row):
url = url1 + table.cell(i,1).value + url2
strhtml = requests.get(url)
if "無線區域網絡" in strhtml.text:
worksheet.write(y,0,label=table.cell(i,1).value) #将有WiFi的人的工号写入表格
y = y+1
print(i) #打印行数
workbook.save('222.xls') #保存并命名为222.xls