python3生成通讯录 可导入手机

#xlsx 表格第A1写名字 B1写电话

import openpyxl
from openpyxl import load_workbook

wb = load_workbook('继续.xlsx')

ws = wb.active


def qu():

    for i in range(1,435):

        name = ws.cell(row=i,column=4).value

        name = str(i)

        tle = ws.cell(row=i,column=2).value

        print(name)

        print(tle)


        with open("通讯.vcf","a",encoding='utf-8')as f:

            f.write('BEGIN:VCARD')

            f.write('\n')

            f.write('VERSION:3.0')

            f.write('\n')

            f.write('N;CHARSET=utf-8:;{0};;;'.format(name))

            f.write('\n')

            f.write('FN;CHARSET=utf-8: {0}'.format(name))

            f.write('\n')

            f.write('TEL;CELL:{0}'.format(tle))

            f.write('\n')

            f.write('END:VCARD')
            
            f.write('\n')
        
qu()