AnsweredAssumed Answered

Search cursor not reading excel files with Python 64

Question asked by Msouff on Jun 15, 2015
Latest reply on Jun 15, 2015 by Msouff

I can't read excel files with data access search cursor since I upgrade to Python 64 background processing. I have the office system drivers so that's not the problem. Also, I was able to read excels files fine before I upgraded. I even tried the same script in a computer running on Python 32 and then in mine with Python 64,.It worked in Python 32, but failed in Python 64 so I'm pretty sure the problem is with Python 64.


Have anyone run into this or knows how to fix it?


Here a simple example of what I can't do anymore:


import arcpy

spreadsheet = r'spreadsheet.xlsx\Sheet1$'

with arcpy.da.SearchCursor(spreadsheet, 'name') as cursor:
     for row in cursor:
          print row[0]