python自动填上每个摄像头显示水印位置

安装chrom浏览器后查看版本：

下载和配置chromedriver(下载的chromdriver版本要和安装的chrom一样)
chromdriver下载地址：https://npm.taobao.org/mirrors/chromedriver/

把下载好的chromdriver拷到2个位置：pyhthon安装主目录和chrom浏览器主目录

from selenium import webdriver
import os,pandas,time,openpyxl,re
from tcping import Ping


def kill_web():
    os.system("taskkill /F /T /IM  chrome.exe")    #完成一个摄像头后关闭网页
    

def login(url, username, password, port, address):
    brower = webdriver.Chrome()
    brower.get(url)  
    time.sleep(3)

    # brower.find_element_by_name("UserName").send_keys(username)
    # brower.find_element_by_name("Password").send_keys(password)
    # time.sleep(5)
    # brower.find_element_by_id("user_protocol1").click()  #点勾同意协议 
    # brower.find_element_by_id("btnLogin").click()  #点击登陆
    # brower.find_element_by_id("address").send_keys(address)   #填入位置名称
    
    kill_web()    #必须是能打开的网站，不然就会卡这到不会关闭网页，所以前面做了判断
        
		
def file_handle(file_path):
    result = pandas.read_excel(file_path, sheet_name = "Sheet1")    
    for index,row in result.iterrows():        
        host = row[1]
        username = row[2]
        password = row[3]
        port = row[4]
        address = row[5]
        url = "https://%s" % host
        ping = Ping(host, 80)  # 地址、端口、超时时间
        ping.ping(3)  # ping命令执行次数
        ret = ping.result.raw # 以表格形式展现（ping.result.raw  # 原始形态，ping.result.rows  # 行显示）
        results = re.findall(r"connections,(.*?)successed,",ret) #正则匹配出来
        ping_result = int(results[0].strip())
        #time.sleep(6)
        if (ping_result != 0):  #不等于0代表ping通了
            login(url, username, password, port, address)
        else:
            print("%s is not open!!!" % url)
            continue
        		
	
if __name__ == "__main__":	
    files = input("please input your ip_address_file path(d:\\\ip_address.xlsx): ").strip()
    file_handle(files)

表格格式如下：