Hello members: I'm trying to validate the existence of a file by an if statement, but it isn't working correctly. The module is a crawler that writes to excel some attributes from the files it finds.
folders = None # look in this (root) folder for files with specified extension for root, folders, files in os.walk( "C:\\" ): file_list.extend(os.path.join(root,fi) for fi in files if fi.endswith(".shp")) wrkbk = Workbook() #Add named parameter to allow overwriting cells: cell_overwrite_ok=True wksht = wrkbk.add_sheet('shp') #... add the headings to the columns wksht.row(0).write(0,'ruta') wksht.row(0).write(1,'archivo') #write the rows for row, filepath in enumerate(file_list, start=1): wksht.row(row).write(0, filepath) (ruta, filename) = os.path.split(filepath) wksht.row(row).write(1, filename) #Here I`m splitting the string filename in base and extension n = os.path.splitext(filename) #Getting the base and prj as its extension p = n[0]+'.prj' #validate if p exists if os.path.lexists(p): wksht.row(row).write(9, 1) prj_text = open(p, 'r').read() wksht.row(row).write(8,prj_text) else: wksht.row(row).write(9, 0) wksht.row(row).write(8, 'Sin prj, no se puede determinar la proyeccion') The issue is that it just identifies 3 prj and I have more, befores I added prj_text = open(p, 'r').read() wksht.row(row).write(8,prj_text) it worked fine and write the correct prj, but now it doesn't What am I doing wrong? Hope you can help me
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor