openpyxl 优点:可支持超过2048字节的字符串写入Excel表
# do: 生成IP并写入Excel表
# person: baizhou
# time: 2022.10.27
import openpyxl
def get_ip(number=10,start='1.1.1.1'):
file=open('1.text','w')
starts=start.split('.')
A=int(starts[0])
B=int(starts[1])
C=int(starts[2])
D=int(starts[3])
for A in range(A,256):
for B in range(B,256):
for C in range(256):
for D in range(D,256):
ip="%d.%d.%d.%d" % (A,B,C,D)
if number > 1:
file.write(ip + '\n')
number -=1
elif number ==1:
file.write(ip)
number -=1
else:
file.close()
return
D=0
C=0
B=0
return file
def write_excel():
with open(r'1.text','r+') as title:
hrtitle=title.read()
hrtitle_list=hrtitle.split()
x=0
wb=openpyxl.Workbook() #创建1个Excel
ws=wb.create_sheet(u'ip',0) #创建一个工作表
# ws.cell(1,2,u'x') # 第一行第二列写入值为x
for x,content in enumerate(hrtitle_list):
cell=ws.cell(row=x+6,colum=1) #从第六行第一列开始写入IP
cell.value=content
wb.save(r"testip.xlsx")
if __name__=='__main__':
s=get_ip(2000,'59.3.220.1') #2000为生成IP的数量
write_excel()
print('over')