Author | Topic: 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_OHR | Re: 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 Aoki | Re: 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 Ziegler | Re: 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! |