topic Re: Accessing values in Excel with getValue in Python Questions

Accessing values in Excel with getValue

JonPedder — Wed, 01 Aug 2012 19:30:21 GMT

Hi, I'm reading in an Excel doc (xlsx) with arcpy and want to use row.getValue() to pull in the information by row and cell. I'm looking to use a SearchCursor() to access the excel file.

My Excel doc is Assignments.xlsx and the first worksheet is named Assignment, which would be referenced in Arc as Assignment$

I'm not sure how to access/read data in the cells?

Thanks

Re: Accessing values in Excel with getValue

MathewCoyle — Wed, 01 Aug 2012 19:51:54 GMT

I would suggest creating a tableview or permanent table depending on what you want to do with the data, and using a search cursor on that.

Re: Accessing values in Excel with getValue

JonPedder — Wed, 01 Aug 2012 19:54:37 GMT

This appears to be working, if I select the worksheet first Assignments$

 import arcpy from arcpy import env arcpy.env.overwriteOutput = True  xcel = arcpy.GetParameterAsText(0) arcpy.AddMessage("Got Sheet")  rows = arcpy.SearchCursor(xcel) row = rows.next() arcpy.AddMessage("Got Rows")  while row:     arcpy.AddMessage("Start While")     # Loop through rowns and pull incident name from Incident_Name field     arcpy.AddMessage("Getting Assignment")          Assignment = row.getValue("Assignment_Number")     Description = row.getValue("Description")     arcpy.AddMessage(Assignment)     arcpy.AddMessage(Description)               arcpy.AddMessage("Received Assignment")     row = rows.next()

just getting started, thanks