按行读表

import IPy as IP
import xlrd
import pandas as pd

# no header
# data = pd.read_excel('F:/test/white_black.xlsx',header=None)

data = pd.read_excel('F:/test/white_black.xlsx')
data_list = []
for i in range(len(data)):
    li = str(data.iloc[i].tolist()[0])
    lis = li.split(',')
    l = lis[0].split('，')
    for j in range(len(l)):
        data_list.append(l[j])

# print(data_list)
all_white_black = []
for i in data_list:
    a = IP.IP(i)
    for j in a:
        #print(j)
        all_white_black.append(str(j))

#print(all_white_black)


# target ip list
target_ip_data = pd.read_excel('F:/test/ip.xlsx')
target_ip_list = []
for i in range(len(target_ip_data)):
    tmp_li = str(target_ip_data.iloc[i].tolist()[0])
    tmp_lis = tmp_li.split()
    tem_l = tmp_lis[0].split()
    for j in range(len(tem_l)):
        target_ip_list.append(tem_l[j])
# print(target_ip_list)
# judege target_ip_list
for i in target_ip_list:
    if i in all_white_black:
        print("%s ture " % i)

    else:
        print("%s false" % i)