外部COM进程不终止的处理方法

Free-Lancer

External COM processes do not terminate, if created with (vlax-get-or-create-object)

By Gopinath Taget

It is recommended that developers call (vlax-release-object...) on all external objects after they are done with them. However, it should be noted that calling (vlax-release-object...) does not always release the object at that exact time. The object is not actually released until all LISP symbols referencing the server's COM objects go out of scope or are set to nil AND a garbage-collection (gc) happens. The actual COM call to "release" happens only in a (gc) and only if LISP agrees that the object is no longer referenced.

You can force a garbage-collection with the lisp function (gc). Before you invoke Excel's Quit method, insert the call to (gc) into your code. This should allow (vlax-release-object ...) to remove Excel.exe from the process list. See below:

2. (defun Test ()
   
3.    (vl-load-com)
   
4.    (setq XLAPP (vlax-get-or-create-object "Excel.Application"))
   
5.    (vlax-dump-object XLAPP T)
   
6.    (gc) ; release temporary com objects
   
7.    (vlax-invoke-method XLAPP 'Quit)
   
8.    (vlax-release-object XLAPP)
   
9.    (setq XLAPP nil)
   
10.    (gc)
    
11. )

(defun Test ()<br />    (vl-load-com)<br />    (setq XLAPP (vlax-get-or-create-object "Excel.Application"))<br />    (vlax-dump-object XLAPP T)<br />    (gc) ; release temporary com objects<br />    (vlax-invoke-method XLAPP 'Quit)<br />    (vlax-release-object XLAPP)<br />    (setq XLAPP nil)<br />    (gc)<br /> )

While this technique is generally supported, it should be noted that forcing too many (gc) calls (i.e. within loops that iterate hundreds of times), will have a negative impact on performance.
  NOTE: The VLIDE may be attached to many COM objects during a debug session. A COM server like Excel, will not be released until all of the internal VLIDE symbols referencing Excel objects go out of scope. The user/developer has no direct control over when the VLIDE internal symbols go out of scope. Closing the VLIDE does not make them go out of scope. The VLIDE never fully goes away once it has been started in a session. If developers are having trouble seeing the COM server released in a timely fashion, they should try running their application without ever having run the VLIDE in a session.