电话号码识别并存入excel

from excelutils import excelutil 
import urllib
import requests,json,xlwt
from bs4 import BeautifulSoup,SoupStrainer
if __name__=='__main__':


    excel_data=[]
    excel=excelutil.excelutil()
    k=-1
    f=xlwt.Workbook(encoding='utf-8')
    sheet01=f.add_sheet(u'sheet1',cell_overwrite_ok=True)
    sheet01.write(0, 0, "number")
    sheet01.write(0, 1, "地区")



    excel_data=excel.read_xlrd(r'C:\Users\xxx\xxx\2.xlsx',1)
   
    print(excel_data)
    for i in range(2,len(excel_data)):
        k += 1
        strdata=", ".join(excel_data[i]) 
        print(strdata)
        #一次查询27各号码
       # url='https://haoma.baidu.com/phoneSearch?search='+strdata+'&position=&request_pag=1'
        url='https://www.ip138.com/mobile.asp?mobile='+strdata+'&action=mobile'
        reponse=requests.get(url=url)
        reponse.encoding='utf-8'
        html=reponse.text
       # print(html)
        soup = BeautifulSoup(html,"html.parser",from_encoding="utf-8")
         
       
        p_node = soup.find('div',class_='fs_14_999')
        #print(p_node)
        if p_node==None:
           p_node = soup.find('div',class_='name')
           if p_node==None:
                p_node = soup.find('div',class_='not_found_text')

        print(strdata, p_node.get_text())
        sheet01.write(k + 1, 0, strdata)
        sheet01.write(k + 1, 1, p_node.get_text())
    f.save(r"C:\Users\xxxx\Desktop\3.xls")