Python-openpyxl小结（含IP和MAC随机生成）

生成随机IP和MAC

    #MAC：
    # ":".join(["%02x" % x for x in map(lambda x: random.randint(0, 255), range(6))])
    #IP
    # socket.inet_ntoa(struct.pack('>I', random.randint(1, 0xffffffff)))

加载原有excal加以修改后保存

import openpyxl
import random
import socket
import struct

def makeOne(wb,i,j):
    sh=wb['one']
    print(sh)
    id=''.join(random.sample('1234567890',10))
    version=''.join(random.sample('1234567890',1))+'.'+''.join(random.sample('1234567890',2))+'.'+''.join(random.sample('1234567890',1))
    im=str(random.choice(['很高','高','中等','低','很低']))
    area = str(random.choice(['成都市', '武侯区', '金牛区', '青羊区', '高新区']))
    softVersion=''.join(random.sam