OWC intreface

Question

Post reply

OWC intreface

Roust_m

SSCoach

Points: 17410
More actions
August 25, 2004 at 12:37 am

#108592

Hi!
Just installed OWC for MS Office 2003, but can not find where to open it: no shortcuts, no menus, etc. Is there some different way to open OWC for cube browsing? Would appriciate any links to introductory information on the subject.
Thanks.
August 30, 2004 at 8:00 am

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mithrandir SSCrazy Points: 2628 More actions · Answer 1

Maybe last post of Alamir in this tread could be useful:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=129940&p=2

Gan Valued Member Points: 71 More actions · Answer 2

Find below the code for getting OWC Excel component in html page. But you will have to pump an XML stream into the OWC component. Also note that OWC used in this example is version 9, while 2003 OWC is version 11. hence, make adjustments accordingly. (Also appropriately replace the emoticons with appropriate decoded String)

All the best.

Cheers

Gan

==============================================

<html xmlns:o="urn:schemas-microsoft-com:office:office"

xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns="http://www.w3.org/TR/REC-html40">

<head>

</head>

<body>

<!--The following information was generated by Microsoft Excel's Publish as Web

Page wizard.-->

<!--If the same item is republished from Excel, all information between the DIV

tags will be replaced.-->

<div id="Test_24468" align=center x:publishsource="Excel"><object

id="Test_24468_WebChart" codebase="file:msowc.cab#version=9,0,0,2710"

classid="CLSID:0002E500-0000-0000-C000-000000000046" width="100%" height="90%">

<param name=XMLData

value="<xml xmlns:x="urn:schemas-microsoft-com:office:excel">

<x:WebChart>

<x:Width>32597</x:Width>

<x:Height>8308</x:Height>

<x:Type>OSP</x:Type>

</xataSource>

<x:Entry>#000000</x:Entry>

<x:Entry>#000080</x:Entry>

<x:Entry>#FF00FF</x:Entry>

<x:Entry>#FFFF00</x:Entry>

<x:Entry>#00FFFF</x:Entry>

<x:Entry>#800080</x:Entry>

<x:Entry>#800000</x:Entry>

<x:Entry>#008080</x:Entry>

<x:Entry>#0000FF</x:Entry>

<x:Entry>#00CCFF</x:Entry>

<x:Entry>#CCFFFF</x:Entry>

<x:Entry>#CCFFCC</x:Entry>

<x:Entry>#FFFF99</x:Entry>

<x:Entry>#99CCFF</x:Entry>

<x:Entry>#FF99CC</x:Entry>

<x:Entry>#CC99FF</x:Entry>

<x:Entry>#FFCC99</x:Entry>

</xalette>

<x:Chart>

<x:Border>

<x:Color>#808080</x:Color>

<x:Weight>1</x:Weight>

</x:Border>

<x:Interior>

<x:Color>#C0C0C0</x:Color>

</x:Interior>

<x:Graph>

<x:Type>Line</x:Type>

<x:SubType>Standard</x:SubType>

<x:SubType>Marker</x:SubType>

<x:Series>

<x:Name>Series</x:Name>

<x:Caption>

</x:Caption>

<x:Index>0</x:Index>

<x:Category>

</x:Category>

<x:Value>

</x:Value>

<x:Marker>

<x:Size>5</x:Size>

</x:Marker>

<x:Explode>0</x:Explode>

</x:Series>

<x:ScaleID>54466024</x:ScaleID>

<x:ScaleID>54466180</x:ScaleID>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>54468324</x:AxisID>

<x:ScaleID>54466024</x:ScaleID>

<x:Type>Category</x:Type>

<x:Font>

<x:FontName>Arial</x:FontName>

<x:Size>10</x:Size>

</x:Font>

<x:Number>

<x:FormatString>General</x:FormatString>

</x:Number>

<x:CrossingAxis>54468976</x:CrossingAxis>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<xlacement>Bottom</xlacement>

</x:Axis>

<x:Axis>

<x:AxisID>54468976</x:AxisID>

<x:ScaleID>54466180</x:ScaleID>

<x:Type>Value</x:Type>

<x:Font>

<x:FontName>Arial</x:FontName>

<x:Size>10</x:Size>

</x:Font>

<x:Number>

<x:FormatString>0.00%</x:FormatString>

</x:Number>

<x:CrossingAxis>54468324</x:CrossingAxis>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

</x:Axis>

</xlotArea>

<x:Name>Chart 2</x:Name>

<x:Legend>

<x:Font>

<x:FontName>Arial</x:FontName>

<x:Size>10</x:Size>

</x:Font>

<xlacement>Right</xlacement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>54466024</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>54466180</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web

page interactively, you must have Microsoft® Internet Explorer 4.01 or later

and the Microsoft Office Web Components.<span style="mso-spacerun: yes">

</span>See the <a

HRef="Microsoft'>http://officeupdate.microsoft.com/office/redirect/fromOffice9/MSOWCPub.htm?&HelpLCID=1033">Microsoft

Office Web site</a> for more information.</p>

</object>

</DIV>

codebase="file:msowc.cab#version=9,0,0,2710"

classid="CLSID:0002E530-0000-0000-C000-000000000046" VIEWASTEXT>

<param name=XMLData

value="">

</object>

<OBJECT classid="CLSID:0002E510-0000-0000-C000-000000000046" codeBase=file:msowc.cab#version=9,0,0,2710

id=Test_24468_WebCalc style="LEFT: 0px; TOP: 0px" VIEWASTEXT>

<PARAM NAME="HTMLData"

value="<html xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns="http://www.w3.org/TR/REC-html40">

<head>

<!--tr

{mso-height-source:auto;}

td

{white-space:nowrap;}

.wc8483F33

{white-space:nowrap;

font-family:Arial;

mso-number-format:General;

font-size:auto;

font-weight:auto;

font-style:auto;

text-decoration:auto;

mso-background-source:auto;

mso-pattern:auto;

mso-color-source:auto;

text-align:general;

vertical-align:bottom;

border-top:none;

border-left:none;

border-right:none;

border-bottom:none;

mso-protection:locked;}

.wcCA26F33

{white-space:nowrap;

font-family:Arial;

mso-number-formatercent;

font-size:10pt;

font-weight:700;

font-style:normal;

text-decoration:auto;

mso-background-source:auto;

mso-pattern:auto;

color:black;

text-align:general;

vertical-align:bottom;

border-top:none;

border-left:none;

border-right:none;

border-bottom:none;

mso-protection:locked;}

.wc0B36F33

{white-space:nowrap;

font-family:Arial;

mso-number-formatercent;

font-size:10pt;

font-weight:400;

font-style:normal;

text-decoration:auto;

mso-background-source:auto;

mso-pattern:auto;

color:black;

text-align:general;

vertical-align:bottom;

border-top:none;

border-left:none;

border-right:none;

border-bottom:none;

mso-protection:locked;}

-->

</style>

</head>

<body>

<!--[if gte mso 9]><xml>

<x:ExcelWorkbook>

<x:ExcelWorksheets>

<x:ExcelWorksheet>

<x:Label Style='border-top:solid .5pt silver;border-left:solid .5pt silver;

border-right:solid .5pt silver;border-bottom:solid .5pt silver'>

<x:Caption>Microsoft Office Spreadsheet</x:Caption>

</x:Label>

<x:Name>Sheet1</x:Name>

<x:WorksheetOptions>

<x:Selected/>

<x:Height>7620</x:Height>

<x:Width>15240</x:Width>

<x:TopRowVisible>0</x:TopRowVisible>

<x:LeftColumnVisible>0</x:LeftColumnVisible>

<xrotectContents>False</xrotectContents>

<x:StandardWidth>2340</x:StandardWidth>

</x:WorksheetOptions>

</x:ExcelWorksheet>

</x:ExcelWorksheets>

<x:SpreadsheetAutoFit/>

<x:MaxHeight>95%</x:MaxHeight>

<x:MaxWidth>95%</x:MaxWidth>

</x:ExcelWorkbook>

</xml><![endif]-->

</tr>

</tr>

</tr>

</table>

</body>

</html>

">

</DIV>

</div>

</body>

</html>

=====================================================