topic Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem in ArcGIS Pro Questions

ArcGIS.Desktop.Core.Geoprocessing.GPItem

Anonymous User — Tue, 04 Jan 2022 21:40:19 GMT

Hello,

I am getting an error in ArcPRO when I try to add excel spreadsheet to ArcPRO I get this error 'exception of type 'ArcGIS.Desktop.Core.Geoprocessing.GPItemException' was thrown'. ArcPRO version 2.9. I just updated to 2.9, but my coworker isn't having these issues. Does anyone know how to fix this error? I am able to add .csv files @KailaBaumBach

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

DanPatterson — Tue, 04 Jan 2022 22:23:59 GMT

Does Excel To Table (Conversion)—ArcGIS Pro | Documentation

fail as well?

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

Robert_LeClair — Wed, 05 Jan 2022 15:54:02 GMT

You'll need to download and install the Microsoft Access Database Engine drive - specifically the 2016 Excel driver as it's needed in order for Excel files to work in ArcGIS Pro. Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

Anonymous User — Wed, 05 Jan 2022 17:40:00 GMT

Thank you. That worked.

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

CharlottePeters95540 — Wed, 04 May 2022 23:00:59 GMT

Installing the driver worked for me too after getting the error with AGP v2.9.

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

Graham — Tue, 05 Jul 2022 16:50:49 GMT

Thanks!

I followed the steps and still got the same error at first. I had to mess with the worksheets to get them to load. it finally seemed to work when i got rid of any merged cells in the sheet i wanted to load. maybe that did it?

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

RonnieRichards — Tue, 05 Jul 2022 21:08:02 GMT

This can also be caused if the Excel workbook is encrypted with a password. The same error with be thrown if the xlsx has a password. The password must be removed from the workbook to be compliant with Desktop or Arcpy in AGP v3.0.

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

Andra — Fri, 26 Aug 2022 19:20:32 GMT

Your solution worked for me! Thank you.

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

AkashKhokhariya09 — Tue, 06 Dec 2022 15:48:32 GMT

This solution did not worked for me!, do you think there would be any other problem. I'm getting same error after installing database driver 2016.

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

secplanrenca — Fri, 13 Jan 2023 14:07:09 GMT

Thank you!!

Re: ArcGIS.Desktop.Core.Geoprocessing.GPItem

ToddAGrissom — Thu, 20 Apr 2023 12:55:47 GMT

Akash,

Make sure you have the correct drivers installed based on the MS Office Install you have from the decision tree here - https://pro.arcgis.com/en/pro-app/latest/help/data/excel/prepare-to-work-with-excel-in-arcgis-pro.htm