工作小脚本（三）小脚本处理excel表利用正则批量分割域名匹配单位写入新表格 

 1 import xlrd
 2 import xlwt
 3 import re
 4 def dataDump():
 5     workbook=xlrd.open_workbook("C:\\Users\\AQB\\Downloads\\网站基本信息20201013 (2).xls")
 6     table=workbook.sheet_by_index(0)
 7     urllist=[]
 8     namelist=[]
 9     punc = '[;|,\']'
10     for i in range(1,table.nrows):
11         url=table.cell(i,1).value
12         name=table.cell(i,0).value
13         s=re.split(punc,url)
14         for i in s:
15             if i is not None:
16                 namelist.append(name)
17                 url="http://"+i
18                 #print(url)
19                 urllist.append(url)
20                 #namelist.append(name)
21     #print(namelist)
22     data_write("C:\\Users\\AQB\\Desktop\\白名单提取.xlsx",namelist,urllist)
23 
24 def data_write(file_path, datas,urls):
25     f = xlwt.Workbook()
26     sheet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True) #创建sheet
27     #将数据写入第 i 行，第 j 列
28     i = 0
29     j=0
30     for data in datas:
31         print(data)
32         sheet1.write(i,j,data)
33         i = i + 1
34     i = 0
35     j=1
36     for data in urls:
37         print(data)
38         sheet1.write(i,j,data)
39         i = i + 1
40     f.save(file_path) #保存文件
41 
42 dataDump()

 

posted @ 2020-10-21 16:15  kailicard  阅读(225)  评论(0)    收藏  举报