BrokenLegMike

Error: Using Search Cursor on XLS File

Discussion created by BrokenLegMike on Feb 19, 2014
Latest reply on Feb 20, 2014 by BrokenLegMike
I am trying to cursor search through a .xls file using
arcpy.SearchCursor


My code is this:
xls = r"\\spatialfiles.work\Local\scripts\python\Excel\Report.xls\'Dataset selection$'"

for row in arcpy.SearchCursor(xls):
     print row.getValue("Layer")

I'm baffled. Yesterday this code worked fine. Today I am getting an error:

IOError: "\\spatialfiles.work\Local\scripts\python\Excel\Report.xls\'Dataset selection$'"
does not exist


The xls file does exist. I can navigate to it in ArcCataloge without issue and view the table. The path is correct because I copied and pasted it right out of Catalogue.

Can anyone suggest why this is occuring?


Thanks,
Mike

Outcomes