用python自动化修改已经固化的auto-ap的名字和ssid信号效果演示

干货，赞一个！

第一版有缺陷bug的代码分享一下吧，要求是excel中登记的一样的房间号要连续登记，不能乱登记！

import openpyxl as xl
import sys
import re


class Logger(object):
    def __init__(self, fileN="Default.log"):
        self.terminal = sys.stdout
        self.log = open(fileN, "a")

    def write(self, message):
        self.terminal.write(message)
        self.log.write(message)

    def flush(self):
        pass


sys.stdout = Logger("D:\\wlan_apname.txt")  # 将输出结果保存到D盘

wb = xl.load_workbook('wlan_aps.xlsx')   # 加载一个wlan_aps.xlsx的excel文件
sheet = wb['Sheet1']  # 工作表名Sheet1

messages = []  # room房间号初始化为空列表
ap_maces = []  # ap的mac地址初始化为空列表
for row in range(3, sheet.max_row + 1):   # 确定行数范围从3到max_row
    # -----------------------------------------------------------------------
    # Func Name       : Automated script to modify ap name
    # Date Created    : 2020-03-18
    # Author          : H3CTE--3771
    # History         :
    # Date           Author                      Modification
    # ------------------------------------------------------------------------
    room_cell = sheet.cell(row, 3)
    mac_address_cell = sheet.cell(row, 4)
    room = str(room_cell.value)
    mac_values = mac_address_cell.value
    mac_add = re.compile(r'(\w\w\w\w)(\w\w\w\w)(\w\w\w\w)')
    mac = mac_add.search(mac_values)
    # print(mac.group())
    new_ap_mac = (mac.group(1) + '-' + mac.group(2) + '-' + mac.group(3)).lower()
    # print(new_ap_mac)
    messages.append(room)  # 将房间号组成一个列表
        ap_maces.append(new_ap_mac)

for rooms in messages:
    if messages.count(rooms) >= 2:  # 找出messages列表中重复2次以上的房间号rooms
        i = messages.count(rooms)
        index = messages.index(rooms)
        for ii in range(i):
            messages[index + ii] = '{}-{}'.format(rooms, ii + 1)
            # 更新rooms重复的元素的值，比如重复3次，则rooms值更换为rooms-1,rooms-2,rooms-3

ap_rename = dict(zip(ap_maces, messages))


def wlan():
    for message in messages:
        print(f'wlan service-template {message[:4]}')
        print(" undo service-template enable")
        print(" " + f'ssid {message[:4]}')
        print(" " + "vlan 68")
        print(" " + "client association-location ap")
        print(" " + "client forwarding-location ap")
        print("vlan 68")
        print(" " + "client-security authentication-location ap")
        print(" " + "service-template enable")

    for k, v in ap_rename.items():
        print(f'wlan rename-ap {k} {v}')
        print(f'wlan ap {v}')
        print(' radio 1')
        print(' radio disable')
        print(f' service-template {v[:4]}')
        print(' radio enable')


if __name__ == '__main__':
    wlan()

官方自带神器vbs，

可实现百万AP的 名字，序列号，信道，服务模板，以及其他精确配置的excel，

转换为可以直接粘贴的txt脚本，

搞个python针对性太高