vb.net arcobjects run "table to excel" gp get error

LiYao — Tue, 30 Sep 2014 06:43:12 GMT

Hello everybody,

I have successfully used vb.net arcobjects to run several geoprocessing tools, but when I ran "Table to excel", I got the following error:

System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.

at ESRI.ArcGIS.Geoprocessing.GeoProcessorClass.Execute(String Name, IVariantArray ipValues, ITrackCancel pTrackCancel)

My code is as follows:

Try

Dim GP As GeoProcessor = New GeoProcessor()

Dim parameters As IVariantArray = New VarArray

parameters.Add("test_db.DBO.Segment")

parameters.Add("D:\dev\SegmentExport.xls")

GP.Execute("TableToExcel_conversion", parameters, Nothing)

Catch ex As Exception

logger.Error("ExportSegmentToExcel: " + ex.ToString)

End Try

Is this caused by the code or library? Thanks for the attention.

Re: vb.net arcobjects run "table to excel" gp get error

ShriramBhutada1 — Tue, 30 Sep 2014 14:19:52 GMT

Hi Li,

Please look at the this forum discussion. This might help.

Regards,

Shriram B.

LiYao — Wed, 01 Oct 2014 00:57:13 GMT

Hi Shriram B, yes it is useful, thanks.