Alaska Software Inc. - embedding excel
Username: Password:
AuthorTopic: embedding excel
Eric Breddam embedding excel
on Tue, 03 Jun 2008 19:15:19 -0700
Is it possible to embed excel into an Xbase++ app so a user can view an
existing excel file?

TIA
AUGE_OHRRe: embedding excel
on Fri, 06 Jun 2008 06:01:57 +0200
hi,

> Is it possible to embed excel into an Xbase++ app so a user can view an
> existing excel file?

i do not know, but i remember that somebody did it with Word
and Xbase++ activeX. While both are from Office perhaps you
can modify the Word sample to Excel ...

greetings by OHR
Jimmy
Eric Breddam Re: embedding excel
on Sun, 08 Jun 2008 13:01:27 -0700
On Fri, 06 Jun 2008 06:01:57 +0200, AUGE_OHR wrote:

> hi,
> 
>> Is it possible to embed excel into an Xbase++ app so a user can view an
>> existing excel file?
> 
> i do not know, but i remember that somebody did it with Word
> and Xbase++ activeX. While both are from Office perhaps you
> can modify the Word sample to Excel ...
> 
> greetings by OHR
> Jimmy

Thank you.  I will look for that example.
Osvaldo L AokiRe: embedding excel
on Fri, 06 Jun 2008 16:33:15 -0300
HI Eric,

    Yes, you can do it using ActiveX.

    But, you have some problems on Office 2007, it open office aplication to 
show...
but, it seem you can modify some registers to open o Xbase Dialog window...

   Osvaldo L Aoki

"Eric Breddam" <eric@somdata.com> escreveu na mensagem 
news:m58julkl4uqx.ywejdksu3u8q.dlg@40tude.net...
> Is it possible to embed excel into an Xbase++ app so a user can view an
> existing excel file?
>
> TIA
Hannes ZieglerRe: embedding excel
on Mon, 09 Jun 2008 03:30:29 +0200
Eric,

despite what others have said, it is NOT possible to embed MS Office 
applications within an XbpDialog window of Xbase++. Only a "faked embedding" 
is possible.

There are two options:

1) Embed the Internet Browser (IE) in XbpDialog and display an MS office 
document within IE

IE is capable of displaying a variety of file formats. The XbpHTMLViewer 
class of Xbase++ embeds IE in XbpDialog. XbpHTMLViewer wraps the 
IWebBrowser2 COM interface for Xbase++. You have a better control of the 
IWebBrowser2 COM interface with The YUKON Project.

2) Obtain the window handle of the MS Office application and move/resize it, 
so that it is displayed within your Xbase++ application. This requires 
complete control of Windows message handling.

Both approaches are possible with The YUKON Project. When you download the 
YUKON Demo from

http://www.knowlexbase.com/en/software/yukon/demo/Yukon_Project_Demo_Setup.zip

I'd like to point you to the \source\samples\yukon\BRW\ directory. The files 
included in this directory re-implement Xbase++'s XbpHTMLViewer class in PRG 
code.

The re-implementation of the Xbase++ class gives valuable information of 
Microsoft's implementation. The PRG example also demonstrates how OLE 
interfaces are glued together.

FWIW, The YUKON Project can solve your problem in a different way.

Regards,
--
Hannes Ziegler


"Eric Breddam" <eric@somdata.com> schrieb im Newsbeitrag 
news:m58julkl4uqx.ywejdksu3u8q.dlg@40tude.net...
> Is it possible to embed excel into an Xbase++ app so a user can view an
> existing excel file?
>
> TIA
Eric Breddam Re: embedding excel
on Sun, 15 Jun 2008 19:25:26 -0700
On Mon, 09 Jun 2008 03:30:29 +0200, Hannes Ziegler wrote:

> Eric,
> 
> despite what others have said, it is NOT possible to embed MS Office 
> applications within an XbpDialog window of Xbase++. Only a "faked embedding" 
> is possible.
> 
> There are two options:
> 
> 1) Embed the Internet Browser (IE) in XbpDialog and display an MS office 
> document within IE
> 
> IE is capable of displaying a variety of file formats. The XbpHTMLViewer 
> class of Xbase++ embeds IE in XbpDialog. XbpHTMLViewer wraps the 
> IWebBrowser2 COM interface for Xbase++. You have a better control of the 
> IWebBrowser2 COM interface with The YUKON Project.
> 
> 2) Obtain the window handle of the MS Office application and move/resize it, 
> so that it is displayed within your Xbase++ application. This requires 
> complete control of Windows message handling.
> 
> Both approaches are possible with The YUKON Project. When you download the 
> YUKON Demo from
> 
> http://www.knowlexbase.com/en/software/yukon/demo/Yukon_Project_Demo_Setup.zip
> 
> I'd like to point you to the \source\samples\yukon\BRW\ directory. The files 
> included in this directory re-implement Xbase++'s XbpHTMLViewer class in PRG 
> code.
> 
> The re-implementation of the Xbase++ class gives valuable information of 
> Microsoft's implementation. The PRG example also demonstrates how OLE 
> interfaces are glued together.
> 
> FWIW, The YUKON Project can solve your problem in a different way.
> 
> Regards,

Thank you Hannes, for a very clear reply.

As it is actually not necessary for me to display the data in my app - just
a nice thing to do and it does have to be non-editable - I'm going to poke
around at using XbpBrowse to display the data via the existing ActiveX
implementation in Xbase++

But again - thanks for your reply - I've been having a difficult time
getting a clear answer on this and it certainly didn't seem to work!