Problem with OLE automation and Microsof Excel [message #453205] |
Thu, 31 March 2005 18:36 |
Boris Munivrana Messages: 23 Registered: July 2009 |
Junior Member |
|
|
Hi there,
Im using swt.ole.win32 to take advantage of the COM-interfaces for
Office apps MSWord and MSExcel (Note: I have Office 2000 installed,
running on Windows 2000 Professional, Service Pack 3).
What Im basically doing is writing data from a SWT.Table into a new Word
document (creating a table there) and, of course, into a new Excel
workbook.
With MSWord, everything works like a charm, but MSExcel causes a problem:
When Excel is closed after the operation (writing the data), there still
remains an EXCEL-background process, as one can see switching to the
Windows Taskmanagers Processes tab, and can only be killed via the
End Process-Menu of the taskmanager.
All this happens even if I dispose all instances of my OleAutomation. In
opposition to that, MSWord REALLY quits after closing the application.
I made a benchmark test using Visual Basic, just to see if Excel behaves
the same way being called remotely, but no, everything worked fine.
Please also note: For MSWord, I make use of Word.Application as the
OleClientSites program id, as it is also used in Visual Basic (see
CreateObject(Word.Application)).
Everything works fine.
Making use of Excel.Application with SWT, the processor load rises up to
a 100% and remains at that level, hence Im using Excel.Sheet as progid,
but
still theres the problem with a remaining background process (Note:
closing Excel with it's "End"-Menu or invoking the "Quit"-Method remotely
via DispatchInterface doesn't make any difference).
Has anybody else made use of MSExcel within his SWT application, and had
an issue with that?
Any help would be appreciated!!!
Thanks,
Boris Munivrana
|
|
|
|
|
|
Re: Problem with OLE automation and Microsof Excel [message #453253 is a reply to message #453243] |
Sat, 02 April 2005 16:57 |
Boris Munivrana Messages: 23 Registered: July 2009 |
Junior Member |
|
|
Hi,Phill,
sounds like a similiar issue, but as opposed to what you describe, I
cannot release the Excel process even if I do dispose all of my automation
objects (= Sheet, Workbook, etc.) EXPLICITLY.
I made a bug report, and hope that this will be fixed soon, since Excel is
one of the most important business software, and OLE automation and Excel
seem to be far from consistent in SWT.
Regards
|
|
|
Powered by
FUDForum. Page generated in 0.02934 seconds