Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Standard Widget Toolkit (SWT) » Non-embedded ActiveX application automation
Non-embedded ActiveX application automation [message #464529] Wed, 23 November 2005 21:31 Go to next message
Stephen Goldbaum is currently offline Stephen Goldbaum
Messages: 75
Registered: July 2009
Member
I'm trying to integrate Excel with an SWT application to call into Excel
to perform some tasks. Ideally, I'd just embed a Sheet in the SWT app,
but displaying Excel in SWT has some serious problems. So I attempted to
automate an Excel application using the IBM bridge2java libraries via the
"Excel.Application" progID. This works outside of SWT, but the
bridge2java and SWT libraries won't co-exsist. I though I might try the
same approach with SWT's OLE functionality. Unfortunately, opening
"Excel.Application" doesn't work. Does anyone know of a another way to
control an Excel app? Can the SWT-OLE libraries by tweeked or augmented
to allow this.

Thanks,
Stephen
Re: Non-embedded ActiveX application automation [message #464534 is a reply to message #464529] Wed, 23 November 2005 21:50 Go to previous messageGo to next message
Veronika Irvine is currently offline Veronika Irvine
Messages: 1272
Registered: July 2009
Senior Member
Have a look at DsoFramer:

http://support.microsoft.com/default.aspx?scid=kb;en-us;311765

You can embed the DSOFramer ActiveX control in SWT using OleControlSite and
DSOFramer can host Excel.

The following bug describes an issue with DsoFramer with a workaround:

https://bugs.eclipse.org/bugs/show_bug.cgi?id=73673



"Stephen Goldbaum" <stephen.goldbaum@lehman.com> wrote in message
news:221ea9ab68370cf9f7aa4c72d0bf23d0$1@www.eclipse.org...
> I'm trying to integrate Excel with an SWT application to call into Excel
> to perform some tasks. Ideally, I'd just embed a Sheet in the SWT app,
> but displaying Excel in SWT has some serious problems. So I attempted to
> automate an Excel application using the IBM bridge2java libraries via the
> "Excel.Application" progID. This works outside of SWT, but the
> bridge2java and SWT libraries won't co-exsist. I though I might try the
> same approach with SWT's OLE functionality. Unfortunately, opening
> "Excel.Application" doesn't work. Does anyone know of a another way to
> control an Excel app? Can the SWT-OLE libraries by tweeked or augmented
> to allow this.
>
> Thanks,
> Stephen
>
Re: Non-embedded ActiveX application automation [message #464643 is a reply to message #464534] Fri, 25 November 2005 19:28 Go to previous messageGo to next message
Stephen Goldbaum is currently offline Stephen Goldbaum
Messages: 75
Registered: July 2009
Member
Hi Veronika,

Thanks for the info. This will certainly do the trick for me. After
playing with brige2java, I've decided I like opening the full Excel
application so the user can open/close files as needed. Is it possible to
accomplish this with the OLE and COM classes?

Thanks,
Stephen
Re: Non-embedded ActiveX application automation [message #464644 is a reply to message #464643] Fri, 25 November 2005 21:01 Go to previous messageGo to next message
Veronika Irvine is currently offline Veronika Irvine
Messages: 1272
Registered: July 2009
Senior Member
How are you launching "the full Excel"?

From the DSOFramer doc:

Open documents

You can also open and edit Office documents that exist on a local drive,
Universal Naming Convention (UNC) share, or Web folder. A standard Open
dialog box that can be displayed by the user or called by code has been
provided, and allows the user to find and select a file to open. You can
also call the Open method directly and give the control a specific file to
open.



"Stephen Goldbaum" <stephen.goldbaum@lehman.com> wrote in message
news:8f71f1563cc2acc1c88f3ea311eb383a$1@www.eclipse.org...
> Hi Veronika,
>
> Thanks for the info. This will certainly do the trick for me. After
> playing with brige2java, I've decided I like opening the full Excel
> application so the user can open/close files as needed. Is it possible to
> accomplish this with the OLE and COM classes?
>
> Thanks,
> Stephen
>
Re: Non-embedded ActiveX application automation [message #464702 is a reply to message #464644] Mon, 28 November 2005 23:16 Go to previous messageGo to next message
Stephen Goldbaum is currently offline Stephen Goldbaum
Messages: 75
Registered: July 2009
Member
I took a better look at DSOFramer. It does look like this would be the
best solution for me. Unfortunately, I can't get it to embed anything.
The "File" dialog appears, but won't react to mouse events. I get
"Catastrophic Failure" when I call "Open", "CreateNew" and "ShowDialog"
(after I've picked a file). Does anyone have a working sample with SWT?

My earlier question was basically whether I could use the COM and OLE
classes to interact with a non-ActiveX or non-visual COM server. WIth
Bridge2Java, I use ProdId "Excel.Application" and it runs an new Excel
process in it's own window. I was wondering if I could do something
similar.

Thanks,
Stephen
Re: Non-embedded ActiveX application automation [message #464954 is a reply to message #464644] Thu, 01 December 2005 21:12 Go to previous message
Stephen Goldbaum is currently offline Stephen Goldbaum
Messages: 75
Registered: July 2009
Member
Did you happen to get any of the code from the thread at
http://dev.eclipse.org/newslists/news.eclipse.platform.swt/m sg17556.html?
I can't seem to get past the "Catastrophic failure" I get whenever I try
to open a document.

Thanks,
Stephen
Previous Topic:Table Column Width
Next Topic:TreeViewer only has small +/- buttons
Goto Forum:
  


Current Time: Thu Oct 23 19:23:22 GMT 2014

Powered by FUDForum. Page generated in 0.02384 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software