Script runs on some computers, fails on others.

[GinoMellino]

Hi, 

I have a script which extracts land parcel polygons from a master dataset based on various user inputs such as local government area, vegetation type, agricultural land class type, etc. One of the outputs of the tool is an excel spreadsheet which I create using arcpy.TableToExcel_conversion. This works fine on my machine but throws the following error on a colleagues machine. Can anyone offer any insight into why this error is occurring? 

Kind Regards, 
Gino

Traceback (most recent call last):

  File "<string>", line 327, in execute

AttributeError: 'module' object has no attribute 'TableToExcel_conversion'

Failed to execute (LandInvestigationShortlistingTool).

[Anonymous User]

Hello,

Are you sharing or using script as tool or script.

Try to create Custom tool using your script and use this with your colleges system.

Most of the time its working without any error.

https://community.esri.com/docs/DOC-8559 

[DanPatterson_Retired · Accepted solution]

They have arcmap installed on their machine as well I presume?  and what version of ArcMap??? Can you open a python window in arcmap on their machine?  Can you import arcpy?  

[JoshuaBixby]

To follow-up on Dan's comments, how are you executing the script, exactly?  Do some of the machines have multiple version or distributions of Python installed?

[GinoMellino]

Confirmed the issue was with the version of ArcGIS on the target users machine. Rookie mistake...Thanks for your help Dan and everyone. 

[SolomonPulapkura]

Does he have the same excel version as you?

Solomon Pulapkura

https://www.vestra.com/gis 

[RebeccaStrauch__GISP]

And depending on the Excel/Office version installed, you may also want to make sure that the compatibility patch for Office is installed, if appropriate.

This thread ARc for Desktop 10.1 and Microsoft Office 2013  had a different issue, but I have seen other threads to that installing the patch helped.

Direct download of the patch Download 2007 Office Sy

stem Driver: Data Connectivity Components from Official Microsoft Download Center 

[GinoMellino]

Hi Guys, 

Thank you for the replies and sorry for the late reply on my part. I think Dan has nailed it, the users are running ArcGIS 10.1 which does not have the Excel tools as I understand they were added at ArcGIS 10.2. I wrongly assumed they would be running the latest version approved by our department, i.e. 10.4.1. 

I will get them upgraded and try again to see if this resolves the problem. 

Cheers for all your help.