Can Excel 2007 PivotTable (xlPivotTableVersion12) be embeded?

[Jon Robertson]

I'm trying to determine if the Excel 2007 PivotTable can be embedded inside
another application, like the PivotTable from OWC. I'm not interested in
Excel Services, as our application is a native Win32 application and our
customers do not have SharePoint deployed.

Thanks

 

[Cindy M.]

Hi Jon,

I'm trying to determine if the Excel 2007 PivotTable can be embedded inside
another application, like the PivotTable from OWC. I'm not interested in
Excel Services, as our application is a native Win32 application and our
customers do not have SharePoint deployed.

Well, unless something has changed in 2007, a Pivot Table is actually
something on a worksheet, in a workbook. So you'd actually be embedding the
workbook, displaying the sheet and range containing the Pivot Table. So your
question really should be, how to embed an Excel workbook.

There are no .NET controls that can display Office COM applications. You still
have to use the old COM DSOFramer or Web Browser controls. I've never really
worked with either, but from what I've read both can work, and both have their
advantages and drawbacks. If you search this newsgroup (an archive going back
a couple of years would be best, if you can find one), and the Internet
generally, you should turn up some discussions.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Osei-Agyemang]

I am sure if you search quite hard enough, you will find a component that can
do the pivot thing. I think Delphi had such a VCL control. I will however not
recommend embedding Excel in a form using the DSOFramer control. I have used
the control myself and it has given me nothing but headaches. The bugs
manifest when it is too late for me to change my mind. Excel was developed as
an application. Embedding it in other applications was an after-thought.
Microsoft withdrew ActiveDocumentHost knowing the problems it had. They then
released DSOFramer (not supported but looks like ActiveDocumentHost) again
knowing the problems it will bring. Microsoft have themselves recommended
using VSTO nowadays instead of embedding Office in applications.

If you are developing the application for your own consumption and your
keyboard has Ctrl+Alt+Del, then use DSOFramer, but if you are developing for
commercial purposes, buy a commercial component. At least, if your customer
holds you by your neck, you can also hold someone's neck.
Lisa->Homer->Bart