to vcard

rehber.py

#!/usr/bin/python
# -*- coding: utf-8 -*-

import xlrd

sayf1 = xlrd.open_workbook("Rehber.xls")

sh = sayf1.sheet_by_index(0)

for i in range(sh.nrows):
	kisi = sh.cell(i,1).value
	numara = sh.cell(i,13).value
	numara = str(numara).strip('.0')
	content = "BEGIN:VCARD\nVERSION:2.1\nN:"+ kisi + ";\nFN:" + kisi +"\nTEL;CELL;VOICE:" + numara + "\nX-CLASS:PUBLIC\nX-NO:0\nEND:VCARD\n"
	gecici = open(kisi + ".vcf","w")
	gecici.write(content.encode("utf-8")) #unicode kullanılmaz cunku donusturme islemi yapmamaktadır..