-
Notifications
You must be signed in to change notification settings - Fork 1
/
ExcelToVcard.py
61 lines (57 loc) · 2.39 KB
/
ExcelToVcard.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
import xlrd
import pandas as pd
import os
#file=os.path.join(os.path.join(os.environ['USERPROFILE']), 'Desktop','Vcard','Contacts.xlsx') #If your excel file not in same directory with python file u can use it
file= 'Contacts.xlsx' #If your excel file in same directory with python file u can use it
excelfile= pd.ExcelFile(file)
column = excelfile.parse('Workers')
s = ""
begin = "BEGIN:VCARD\nVERSION:2.1"
for i in range(len(column)):
fName=""
sName=""
mName= ""
prefix =""
suffix =""
secMail=""
secOrg=""
secTit=""
if(str(column["Phone"][i])!="nan"):
if(str(column["Name"][i])!="nan"):
fName=str(column["Name"][i])
if(str(column["Surname"][i])!="nan"):
sName=str(column["Surname"][i])
if("Suffix" in column.columns.values):
suffix = ""
if(str(column["Suffix"][i])!="nan"):
suffix=str(column["Suffix"][i])+" "
if("Prefix" in column.columns.values):
prefix=""
if(str(column["Prefix"][i])!="nan"):
prefix=str(column["Prefix"][i])+" "
if("MiddleName" in column.columns.values):
mName=" "
if(str(column["MiddleName"][i])!="nan"):
mName=" " + str(column["MiddleName"][i])+" "
secN="\nN:"+ sName + ";" + fName + ";"+mName.strip()+";"+prefix.strip()+";"+suffix.strip()
secFN="\nFN:" + prefix + "" + fName + mName + sName + "," + suffix
# secPhone="\nTEL;CELL:+"+str(column["Phone"][i]).split(".")[0] #v1
secPhone="\nTEL;CELL:+"+str(column["Phone"][i]) #v2
# print("Phone ",secPhone) #For testing purposes
if("Mail" in column.columns.values):
secMail=""
if(str(column["Mail"][i]) != "nan"):
secMail="\nEMAIL;HOME:"+str(column["Mail"][i])
if("Organization" in column.columns.values):
secOrg=""
if(str(column["Organization"][i]) != "nan"):
secOrg="\nORG:" + str(column["Organization"][i])
if("Title" in column.columns.values):
secTit=""
if(str(column["Title"][i]) != "nan"):
secTit="\nTITLE:" + str(column["Title"][i])
s+=begin+secN + secFN +secPhone + secMail+ secOrg+ secTit+"\nEND:VCARD\n"
text_file = open("Exported.vcf", "w",encoding="utf-8") #Encoding utf-8 added
text_file.write(s)
text_file.close()
print("Completed!")