pip install phone 

from phone import Phone
if __name__ == "__main__":
    phoneNum = '17613394466'
    info = Phone().find(phoneNum)
    print(info)
    try:
        phone = info['phone']
        province = info['province']
        city = info['city']
        zip_code = info['zip_code']
        area_code = info['area_code']
        phone_type = info['phone_type']
    except:
        print('none')

from phone import Phone
import xlrd
import xlwt
def Get_Excel_data():
    file = './Tel.xlsx'   #電話號(hào)碼存儲(chǔ)的excle表
    re1 = xlrd.open_workbook(file)
    outwb = xlwt.Workbook() #創(chuàng)建工作簿
    # print(type(outwb))
    outws = outwb.add_sheet("new")  #在工作簿中新建一個(gè)工作表new
    # print(type(outws))
    # 讀取第一個(gè)sheet
    ws = re1.sheet_by_index(0)
    rows = ws.nrows
    # print(rows)
    outws.write(0, 0, u'電話號(hào)')  #給新表的第一行添加對應(yīng)的標(biāo)簽
    outws.write(0, 1, u'省份')
    outws.write(0, 2, u'城市')
    outws.write(0, 3, u'區(qū)號(hào)')
    outws.write(0, 4, u'運(yùn)營商')
    for i in range(0, rows):
        Telvalue = int(ws.cell_value(i, 0))
        # print(Telvalue)
        data = Phone().find(Telvalue)
        print(data)
        outws.write(i + 1, 0, Telvalue)  #給新表的個(gè)列添加對應(yīng)的數(shù)據(jù)
        try:
            outws.write(i + 1, 1, data['province'])
            outws.write(i + 1, 2, data['city'])
            outws.write(i + 1, 3, data['area_code'])
            outws.write(i + 1, 4, data['phone_type'])
            outwb.save(r'New_Tel.xls')
        except:
            print("none")
Get_Excel_data()