excel2vcard.py

#
## Name: Excel2VCard
## Author: Max Base
## Date: 2022/11/30
## Repository: https://github.com/basemax/Excel2Vcard
#

# Setting
INPUT = 'input.txt'
OUTPUT = 'output.vcard'
DEFAULT_INTERNATIONAL_CODE = '+962'

# Function
def main():
    # utf8 read
    with open(INPUT, 'r', encoding='utf-8') as f:
        lines = f.readlines()
        
        rows = [x.split('\t') for x in lines]
        print(rows)

        if len(rows) == 0:
            print('No data')
            return

        # create the OUTPUT file
        with open(OUTPUT, 'w', encoding='utf-8') as f:
            for row in rows:
                name = row[0].strip()
                name = "Ananaseh: " + name

                phone = row[1].strip()
                if phone.startswith('0'):
                    phone = DEFAULT_INTERNATIONAL_CODE + phone[1:]

                # write the vcard
                f.write('''BEGIN:VCARD
VERSION:2.1
N:;{};;;
FN:{}
TEL;CELL:{}
END:VCARD
'''.format(name, name, phone))

# Run
if __name__ == '__main__':
    main()