Eclipse Community Forums: Standard Widget Toolkit (SWT) » Non-embedded ActiveX application automation

Help

Home

Home » Eclipse Projects » Standard Widget Toolkit (SWT) » Non-embedded ActiveX application automation

Show: Today's Messages :: Show Polls :: Message Navigator

Non-embedded ActiveX application automation [message #464529]

Wed, 23 November 2005 21:31

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

Report message to a moderator

Re: Non-embedded ActiveX application automation [message #464534 is a reply to message #464529]

Wed, 23 November 2005 21:50

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
>

Report message to a moderator

Re: Non-embedded ActiveX application automation [message #464643 is a reply to message #464534]

Fri, 25 November 2005 19:28

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

Report message to a moderator

Re: Non-embedded ActiveX application automation [message #464644 is a reply to message #464643]

Fri, 25 November 2005 21:01

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
>

Report message to a moderator

Re: Non-embedded ActiveX application automation [message #464702 is a reply to message #464644]

Mon, 28 November 2005 23:16

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

Report message to a moderator

Re: Non-embedded ActiveX application automation [message #464954 is a reply to message #464644]

Thu, 01 December 2005 21:12

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

Report message to a moderator

Previous Topic:	Table Column Width
Next Topic:	TreeViewer only has small +/- buttons

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 02:47:10 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter