import renn#读取目标文本文件ndef get_str(path):n f = open(path,encoding="utf-8")n data = f.read()n f.close()n return datann# 正则获取文本号码ndef get_phone_number(str):n res = re.findall(r'(13d{ 9}|14[5|7]d{ 8}|15d{ 9}|166{ d{ 8}|17[3|6|7]{ d{ 8}|18d{ 9})', str)n return resnn#保存得到号码ndef save_res(res,save_path):n save_file = open(save_path, 'w')n for phone in res:n save_file.write(phone)n save_file.write('n')n save_file.write('n号码共计:'+str(len(res)))n save_file.close()n print('号码读取OK,号码共计:'+str(len(res)))nnif __name__ == '__main__':n path=input("请输入文件路径:")n save_path=input("请输入文件保存路径:")n #read_str=get_str(path)n res=get_phone_number(get_str(path))n save_res(res,save_path)
将提取的手机号存入 Excel
#coding:utf-8nimport xlwtnn#读取目标文本文件ndef get_str(path):n f = open(path, encoding="utf-8")n data = f.read()n f.close()n return datannndef save_excel(save_path,sheetname,column_name_list,read_list):n workbook = xlwt.Workbook()nn sheet1 = workbook.add_sheet(sheetname=sheetname)nn for i in range(0,len(column_name_list)):n sheet1.write(0,i,column_name_list[i])n i = 1n for v in read_list:n kval = v.split(':')n for j in range(0, len(kval)):n sheet1.write(i + 1, j, kval[j])n print(kval[j])n i = i + 1n#保存为Excel文件ndef save_excel(save_path,sheetname,column_name_list,read_list):n workbook = xlwt.Workbook()n sheet1 = workbook.add_sheet(sheetname=sheetname)n for i in range(0,len(column_name_list)):n sheet1.write(0,i,column_name_list[i])n i=1n for v in read_list:n kval=v.split(' :')n for j in range(0,len(kval)):n sheet1.write(i+1,j,kval[j])n i=i+1n workbook.save(save_path)n print('信息保存 OK
,记录条数共计:'+str(len(read_list)))nnif __name__ == '__main__':n path = input("请输入文件路径:")n save_path = input("请输入文件保存路径
:")n sheet_name = input("请输入sheetname:")n column_name = input("请输入列名,并且使用英文逗号隔开:")n column_name_list = column_name.split(',')nn read_str = get_str(path)n read_list = read_str.split('n')n save_excel(save_path, sheet_name, column_name_list, read_list)