已知IP和子网掩码批量计算出起始IP和终止IP
已知条件
程序
from IPy import IP
import IPy
import xlwt
import xlrd
file_path = 'D:\\Py-thon\\pyhon-yunwei\\ip转换.xlsx'
xl = xlrd.open_workbook(r'D:\\Py-thon\\pyhon-yunwei\\ip转换.xlsx')
table = xl.sheet_by_name(sheet_name='Sheet1')
list_01 = table.col_values(2,1,) #IP列横向数在xlsx中是2,纵向数是1,直到最后一个
#print(len(list_01))
list_02 = table.col_values(3,1,) #掩码列
#print(len(list_02))
for item in range(len(list_01)):
ip = list_01[item] #取出IP
Netmask = list_02[item] #取出掩码
ip_duan = IP(ip).make_net(Netmask).strNormal() #IP段 例如:192.168.1.1/24
#print(ip_duan)
ips = IPy.IP(ip_duan)
print(ips[1],ips[-2])
执行结果: