Geek Answers Handbook

OWC PivotTable Toolbar Element Highlighted for WebForm

I am trying to create a Pivottable on a web form in vb.net 2005 using OWC. I added the Pivottable element to the toolbar, but it is inactive and therefore I can not use it. If I create Winform instead of Webform, then the toolbar elements work and work correctly.

+4
source share
1 answer

Office Web Components are ActiveX controls. You cannot add them to a web page through the WebForms designer. That is why they are disabled (grayed out). WinForms can host ActiveX controls, so components are not disabled when forms are developed.

To add a pivot table to a web page, use the object element and specify the classid from "clsid: 0002E55A-0000-0000-C000-000000000046". See examples below.

Example

The following is the resulting code when adding a pivot table to a web page using FrontPage 2003.

 <object classid="clsid:0002E55A-0000-0000-C000-000000000046" id="PivotTable1"> <param name="XMLData" value="&lt;xml xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt; &lt;x:PivotTable&gt; &lt;x:OWCVersion&gt;11.0.0.8304 &lt;/x:OWCVersion&gt; &lt;x:DisplayScreenTips/&gt; &lt;x:CubeProvider&gt;msolap.2&lt;/x:CubeProvider&gt; &lt;x:CacheDetails/&gt; &lt;x:PivotView&gt; &lt;x:IsNotFiltered/&gt; &lt;/x:PivotView&gt; &lt;/x:PivotTable&gt; &lt;/xml&gt;"> <table width="100%" cellpadding="0" cellspacing="0" border="0" height="8"> <tr> <td bgcolor="#336699" height="25" width="10%">&nbsp;</td> <td bgcolor="#666666" width="85%"><font face="Tahoma" color="white" size="4"><b>&nbsp; Missing: Microsoft Office Web Components</b></font></td> </tr> <tr> <td bgcolor="#cccccc" width="15">&nbsp;</td> <td bgcolor="#cccccc" width="500px"><br> <font face="Tahoma" size="2">This page requires the Microsoft Office Web Components.<p align="center"> <a href="D:/ENGLISH/OFFICE_SYSTEM/OFFICEPRO2003/files/owc11/setup.exe">Click here to install Microsoft Office Web Components.</a>.</p></font><p><font face="Tahoma" size="2">This page also requires Microsoft Internet Explorer 5.01 or higher.</p><p align="center"><a href="http://www.microsoft.com/windows/ie/default.htm"> Click here to install the latest Internet Explorer</a>.</font><br>&nbsp;</td> </tr> </table> </object>

The following is the resulting code when adding a pivot table to a web page using SharePoint Designer 2007.

 <object classid="clsid:0002E55A-0000-0000-C000-000000000046" id="PivotTable1"> <param name="XMLData" value="&lt;xml xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt; &lt;x:PivotTable&gt; &lt;x:OWCVersion&gt;11.0.0.8304 &lt;/x:OWCVersion&gt; &lt;x:DisplayScreenTips/&gt; &lt;x:CubeProvider&gt;msolap.2&lt;/x:CubeProvider&gt; &lt;x:CacheDetails/&gt; &lt;x:PivotView&gt; &lt;x:IsNotFiltered/&gt; &lt;/x:PivotView&gt; &lt;/x:PivotTable&gt; &lt;/xml&gt;" /> </object>

Below is the resulting code using Microsoft Excel 2003 Save as a web page with the "Add interactivity" check.

 <!--[if !excel]>&nbsp;&nbsp;<![endif]--> <!--The following information was generated by Microsoft Office Excel Publish as Web Page wizard.--> <!--If the same item is republished from Excel, all information between the DIV tags will be replaced.--> <!-----------------------------> <!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD --> <!-----------------------------> <div id="Book1_31522" align=center x:publishsource="Excel"><object id="Book1_31522_Spreadsheet" classid="CLSID:0002E559-0000-0000-C000-000000000046"> <param name=DisplayTitleBar value=false> <param name=Autofit value=true> <param name=DataType value=XMLData> <param name=XMLData value="[AMJ - REMOVED FOR POSTING]"> <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web page interactively, you must have Microsoft® Internet Explorer 5.01 Service Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components.</p> <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>See the <a href="http://r.office.microsoft.com/r/rlidmsowcpub?clid=1033&amp;p1=Excel">Microsoft Office Web site</a> for more information.</p> </object></div> <!-----------------------------> <!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD--> <!----------------------------->
+1
source

More articles:


All Articles