byoungs32

SearchCursor + Excel .XLSX Files

Discussion created by byoungs32 on Jun 6, 2012
Latest reply on Jun 8, 2012 by byoungs32
All,

I have several scripts that utilize the SearchCursor in ArcPy to pull info from .xls files, and it works very well. When I try the same approach using a Excel 2007+ .xlsx file, I get an "ERROR 999999: Error Executing Function". I read the following from the Desktop 10 Help:

If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded here from the Microsoft Download Center. If you have Microsoft Excel 2010 or no version of Microsoft Excel installed, you must install the 2007 driver before you can use either .xls or .xlsx files.


Now I realize I don't have Excel 2007 installed on my server, and I dont think I have the 2007 Office System Driver installed either. Funny thing is that I can view the .xlsx file through Catalog with no issues. So it doesnt seem like the driver is the issue.

Is there a known issue trying to use the SearchCursor with .xlsx files or is there a trick to this? I suppose I could go the route of pulling in another Python module to handle these files (XLRD?), but in my environment it is difficult to bring in outside software.

Thanks in advance for any advice you may have.

Outcomes