Latest Contributions by JimKivela

‎06-24-2014

Thanks to the AS400 application that reads this file in, I actually have to save it down to Excel 03 format (this is run on a machine running Office 07)... //Save xls down to excel 03 FileFormat wbk.SaveAs(filePath + fileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel8, null, null, null, null, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, null, null, null, null, null); wbk.Close(true,filePath + fileName, false); objExcel.Quit(); Using Finally to release the COM object (objExcel for the application)... finally { if (wbk != null) { Marshal.ReleaseComObject(wbk); } if (wsheet != null) { Marshal.ReleaseComObject(wsheet); } if (objExcel != null) { Marshal.ReleaseComObject(objExcel); } if (curs != null) { Marshal.ReleaseComObject(curs); } if (cursUG != null) { Marshal.ReleaseComObject(cursUG); } }

‎06-23-2014

I have an application written in C# that runs from within ArcMap and it creates an Excel file on the fly using Microsoft.Office.Interop.Excel objects. It works fine except the Excel process hangs until you close ArcMap. In the code I save and close the workbook object, quit the Excel application object and then do a Marshal.ReleaseComObject on them. I thought this was supposed to terminate the Excel process but that doesn't happend until ArcMap is closed. I had a VB6 version of this application and in that case I did a save and close on the workbook object, quit the Excel application object and set them all = Nothing. This worked as the Excel process ended when the application completed running, you didn't have to close ArcMap. So... anybody know what else I have to do in C# to make the Excel process terminate, without closing ArcMap? Thanks.

‎05-18-2011

Hi - I have about 40,000 point features that I need to loop over and inspect the complex edges that are connected to them. This data is in a geometric network. Due to the amount of data I'm a little concerned about efficiency. My first thought was to use IForwardStar like usual but I'm wondering if IGeometricNetwork::SearchForNetworkFeature would be quicker. I will not be tracing further up the network at all, just looking at the complex edges connected to the points. Any thoughts on this? Thanks.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by JimKivela

Re: C# Release Excel Objects

C# Release Excel Objects

Geometric Network - which is more efficient method?