Convert a xls file to a ldif file

I create this script to convert this xls file:

15545345078	Cabral, Marcos	MARKETANDSENSE_DISTRIBUCION
23121234725	Almada, Hector	MARKETANDSENSE_DISTRIBUCION
354534573458	Samudio, Adan	MARKETANDSENSE_DISTRIBUCION
37293884549	Portillo, Oscar	MARKETANDSENSE_DISTRIBUCION
42453241647	Portillo, Juan	MARKETANDSENSE_DISTRIBUCION
42810425450	Duarte, Osvaldo	MARKETANDSENSE_DISTRIBUCION
44845045455	Mario Sarabia	MARKETANDSENSE_DISTRIBUCION
43731232548	Galeano, Cesar	MARKETANDSENSE_DISTRIBUCION
47459844808	Cabrera, Víctor	MARKETANDSENSE_DISTRIBUCION
48244324525	Perez, Carlos	MARKETANDSENSE_DISTRIBUCION
51032456441	Anibal Barreto	MARKETANDSENSE_DISTRIBUCION

I interesting in the first and second column. The first columns is the NumeroDocumentoIdentidad attribute in the ldap and the second columns is the uid, cn attribute.

#!/usr/bin/env python
#-*- coding: utf-8 -*-
# Author:  peter --<pjl@hpc.com.py>
# Purpose: Insert users info from a xls file
# Created: 22/12/11


# this is the module that help me with the xls file
#http://pypi.python.org/pypi/xlrd
import xlrd
import codecs
import re

coma = re.compile(",")
enie = re.compile("ñ")

#----------------------------------------------------------------------
def InsertFromods(filename):
    """make a ldap entry from a ods file"""
    wb = xlrd.open_workbook(filename)
   
    sh = wb.sheet_by_index(0)

    #for every entry we make a ldif
    filen = codecs.open("entries.ldif", "a+", "utf-8")
    #the last uidNumber attribute in the ldap directory
    val = 2435
   
    for rownum in range(sh.nrows):
        row = sh.row_values(rownum)
        value = sh.row_values(rownum)[1].lower()
       
        value = value.replace(u"ñ", u"n")       
        #try to organizate the second column values
        if  coma.search(value):
            ape = value.split(",")[0].strip()
            nom = value.split(",")[-1].strip()
        else:
            ape = value.split()[0].strip()
            nom = value.split()[-1].strip()
          
        #pass
        filen.write("dn: uid=%s%s,ou=usuarios,dc=rkf,dc=org\n" % (nom, ape))
        filen.write("Empresa: Market and Sense\n")
        filen.write("NumeroDocumentoIdentidad: %s\n" % row[0])
        filen.write("cn: %s %s\n"  % (nom, ape))
        filen.write("sn: %s\n"  % ape)           
        filen.write("objectClass: posixAccount\n")
        filen.write("objectClass: top\n")
        filen.write("objectClass: inetOrgPerson\n")
        val = val + 1
        filen.write("uid: %s%s\n" % (nom, ape))                       
        filen.write("uidNumber: %s\n"  % str(val))
        filen.write("gidNumber: %s\n"  % str(val))
        filen.write("homeDirectory: /homedirs/%s%s\n" % (nom, ape))

        filen.write("\n")
        filen.write("\n")           
    filen.close()
   
#----------------------------------------------------------------------

if __name__=='__main__':
    InsertFromods('marketandsensetablada.xls')