Oct-19-2018, 02:51 AM
So I have iterated over a text file to create a dataset with feature classes in a new gdb. I am having trouble trying to figure out how to modify the script to do this reading directly off an excel file. I would convert it but I have to do it directly. My spreadsheet has 3 worksheets but I need it to work if more are added later also.
import arcpy, fileinput, os
arcpy.env.workspace = "C:/path"
folder = "C/path"
database = "GPS_Results.gdb"
fdataset = "Study_Areas"
spatialref = arcpy.SpatialReference("NAD 1983 UTM Zone 12N")
arcpy.CreateFileGDB_management(folder + "/", database)
arcpy.CreateFeatureDataset_management(os.path.join(folder, database), fdataset, spatialref)
for textfile in arcpy.ListFiles("*.txt"):
newfc = os.path.splitext(textfile)[0]
outpath = os.path.join(folder, database, fdataset)
arcpy.CreateFeatureclass_management(outpath, newfc, "POINT")
cursor = arcpy.da.InsertCursor(os.path.join(outpath, newfc), ["SHAPE@"])
point = arcpy.Point()
infile = os.path.join(folder, textfile)
skipline = 0
for line in fileinput.input(infile):
if skipline != 0:
point.ID, point.X, point.Y = line.split( )
cursor.insertRow([point])
else:
skipline += 1
del cursor