Hooking up OWC PivotTable to OWC SpreadSheet - How?

D

Dan

So, I've got a spreadsheet control on a page with a bunch of data in
it. Now I want to hookup a pivottable control to it...but I can't for
the life of me figure out how. I look in commands and options for the
PT, but done see the SS listed...

Here's the HTML for my page. Any help, appreciated. Oh, and if there
is an easier way to get CSV data into the PT, that's fine with me too
:).

Thanks a bunch,
-Dan

(sorry for the relatively long source snippet - not sure what portion
of the SS XML I really needed to include)


<html>

<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<title>New Page 1</title>
</head>

<body>
<object classid="clsid:0002E551-0000-0000-C000-000000000046" id="ss1">
<param name="DataType" value="XMLDATA">
<param name="XMLData" value="&lt;?xml version=&quot;1.0&quot;?&gt;
&lt;ss:Workbook xmlns:x=&quot;urn:schemas-microsoft-com:eek:ffice:excel&quot;
xmlns:ss=&quot;urn:schemas-microsoft-com:eek:ffice:spreadsheet&quot;
xmlns:c=&quot;urn:schemas-microsoft-com:eek:ffice:component:spreadsheet&quot;&gt;
&lt;x:ExcelWorkbook&gt;
&lt;x:protectStructure&gt;False&lt;/x:protectStructure&gt;
&lt;x:ActiveSheet&gt;0&lt;/x:ActiveSheet&gt;
&lt;/x:ExcelWorkbook&gt;
&lt;ss:Styles&gt;
&lt;ss:Style ss:ID=&quot;Default&quot;&gt;
&lt;ss:Alignment ss:Horizontal=&quot;Automatic&quot;
ss:Rotate=&quot;0.0&quot; ss:Vertical=&quot;Bottom&quot;
ss:ReadingOrder=&quot;Context&quot;/&gt;
&lt;ss:Borders&gt;
&lt;/ss:Borders&gt;
&lt;ss:Font ss:FontName=&quot;Arial&quot; ss:Size=&quot;10&quot;
ss:Color=&quot;Automatic&quot; ss:Bold=&quot;0&quot;
ss:Italic=&quot;0&quot; ss:Underline=&quot;None&quot;/&gt;
&lt;ss:Interior ss:Color=&quot;Automatic&quot;
ss:pattern=&quot;None&quot;/&gt;
&lt;ss:NumberFormat ss:Format=&quot;General&quot;/&gt;
&lt;ss:protection ss:protected=&quot;1&quot;/&gt;
&lt;/ss:Style&gt;
&lt;/ss:Styles&gt;
&lt;c:ComponentOptions&gt;
&lt;c:Label&gt;
&lt;c:Caption&gt;Microsoft Office Spreadsheet&lt;/c:Caption&gt;
&lt;/c:Label&gt;
&lt;c:MaxHeight&gt;80%&lt;/c:MaxHeight&gt;
&lt;c:MaxWidth&gt;80%&lt;/c:MaxWidth&gt;
&lt;c:NextSheetNumber&gt;4&lt;/c:NextSheetNumber&gt;
&lt;/c:ComponentOptions&gt;
&lt;x:WorkbookOptions&gt;
&lt;c:OWCVersion&gt;10.0.0.5605 &lt;/c:OWCVersion&gt;
&lt;x:Height&gt;7620&lt;/x:Height&gt;
&lt;x:Width&gt;15240&lt;/x:Width&gt;
&lt;/x:WorkbookOptions&gt;
&lt;ss:Worksheet ss:Name=&quot;Sheet1&quot;&gt;
&lt;x:WorksheetOptions&gt;
&lt;x:Selected/&gt;
&lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
&lt;x:Selection&gt;R6C3&lt;/x:Selection&gt;
&lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
&lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
&lt;x:protectContents&gt;False&lt;/x:protectContents&gt;
&lt;/x:WorksheetOptions&gt;
&lt;c:WorksheetOptions&gt;
&lt;/c:WorksheetOptions&gt;
&lt;ss:Table ss:ExpandedColumnCount=&quot;3&quot;
ss:ExpandedRowCount=&quot;5&quot;
ss:DefaultColumnWidth=&quot;48.0&quot;
ss:DefaultRowHeight=&quot;12.75&quot;&gt;
&lt;ss:Row&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;String&quot;&gt;one&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;String&quot;&gt;two&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;String&quot;&gt;three&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;/ss:Row&gt;
&lt;ss:Row&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;1&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;1&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;1&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;/ss:Row&gt;
&lt;ss:Row&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;1&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;1&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;2&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;/ss:Row&gt;
&lt;ss:Row&gt;
&lt;ss:Cell ss:StyleID=&quot;Default&quot;&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;1&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell ss:StyleID=&quot;Default&quot;&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;2&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;1&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;/ss:Row&gt;
&lt;ss:Row&gt;
&lt;ss:Cell ss:StyleID=&quot;Default&quot;&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;1&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell ss:StyleID=&quot;Default&quot;&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;2&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;ss:Cell&gt;
&lt;ss:Data ss:Type=&quot;Number&quot;&gt;2&lt;/ss:Data&gt;
&lt;/ss:Cell&gt;
&lt;/ss:Row&gt;
&lt;/ss:Table&gt;
&lt;/ss:Worksheet&gt;
&lt;ss:Worksheet ss:Name=&quot;Sheet2&quot;&gt;
&lt;x:WorksheetOptions&gt;
&lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
&lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
&lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
&lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
&lt;x:protectContents&gt;False&lt;/x:protectContents&gt;
&lt;/x:WorksheetOptions&gt;
&lt;c:WorksheetOptions&gt;
&lt;/c:WorksheetOptions&gt;
&lt;/ss:Worksheet&gt;
&lt;ss:Worksheet ss:Name=&quot;Sheet3&quot;&gt;
&lt;x:WorksheetOptions&gt;
&lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
&lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
&lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
&lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
&lt;x:protectContents&gt;False&lt;/x:protectContents&gt;
&lt;/x:WorksheetOptions&gt;
&lt;c:WorksheetOptions&gt;
&lt;/c:WorksheetOptions&gt;
&lt;/ss:Worksheet&gt;
&lt;/ss:Workbook&gt;
">
<param name="AllowPropertyToolbox" value="-1">
<param name="AutoFit" value="0">
<param name="Calculation" value="-4105">
<param name="Caption" value="Microsoft Office Spreadsheet">
<param name="DisplayColumnHeadings" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayOfficeLogo" value="-1">
<param name="DisplayPropertyToolbox" value="0">
<param name="DisplayRowHeadings" value="-1">
<param name="DisplayTitleBar" value="0">
<param name="DisplayToolbar" value="-1">
<param name="DisplayVerticalScrollBar" value="-1">
<param name="DisplayWorkbookTabs" value="-1">
<param name="EnableEvents" value="-1">
<param name="MaxHeight" value="80%">
<param name="MaxWidth" value="80%">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirection" value="-4121">
<param name="RightToLeft" value="0">
<param name="ScreenUpdating" value="-1">
<param name="EnableUndo" value="-1">
</object>

<object id=pt1 classid=CLSID:0002E552-0000-0000-C000-000000000046>
<param name="XMLData" value="&lt;xml
xmlns:x=&quot;urn:schemas-microsoft-com:eek:ffice:excel&quot;&gt;
&lt;x:pivotTable&gt;
&lt;x:OWCVersion&gt;10.0.0.5605 &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>
</body>
</html>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotTable bug with custom groups ? 0
I am trying to understand this code... 3
union query not displaying? 5
XMLData and ChartSpace 2
Please help, FP generated code produces a "Too few parameters. Expected1" error! 7
Embedding Outlook objects into a web page 3
Database Results Error 2
Problem with form validation 1

Top