Help: Office Web Components (OWC)??

Printable View

Dec 8th, 2003, 01:42 AM
ddolheguy

Help: Office Web Components (OWC)??

I am very new to Office Web Components (OWC) and need to place a spreadsheet into a web page and load it with data from an SQL database.

I currently have the following in my default.aspx page:

Code:

<body> <form id="Form1" method="post" runat="server"> <OBJECT id="ss">{WEB COMPONENT OBJECT}</OBJECT> </form> </body>

I would like to be able to control the OBJECT from within VB.NET.

Can this be done and how??

I am able to use a client side scripting language to control the spreadsheet, but need to use ASP.NET language as I want to integrate into a .net web site.
Dec 8th, 2003, 12:24 PM
MasterBlaster

If I'm not mistaken an owc spreadsheet can be bound to xml. I've only ever used the owc pivot table, but I am guessing it is not all that different. this is a pretty good write up on olap and owc reporting. It also shows how to use a web service to control it which I think is what your looking for. Hope this helpshttp://msdn.microsoft.com/msdnmag/is...P/default.aspx
Dec 8th, 2003, 03:11 PM
ddolheguy

Thank you for the response, but unfortunately I am not looking for an XML solution.

I have developed an intranet reporting web site and need to pull data directly from an SQL database. I was intending on using ADO.net to control this end of the equation.

What I am trying to do is communicate with the Spreadsheet object from the VB.NET backend code.
Dec 8th, 2003, 05:10 PM
MasterBlaster

Yes I know and that is exactly what I gave you. If you look at the sample, the properties of an owc control should be able to be controled using it's xmldata property. This may sound like that property is actually the data being displayed. It is not. It is xml that can set the controls data source, connection type, hell even the font colors if you want. you can create an aspx page or web service(which I prefer and is shown in the example I gave you) using c#/vb to create that xml data and control the owc from your server. You can use ADO OLAP, XML or whatever as your datasource. It dosn't matter.
Dec 8th, 2003, 05:17 PM
MasterBlaster

Mabe this will clarify it a bit.

1.Create a spreadsheet object in you vb code behind or web service.

2. set all of It's properties to what you want them to be

3. calling yourspreadsheet.xmldata should return xml containing everything you need to create an exact mirror of you server side object on your client.

4. pass the xml to you client

5. assign th xmldata created on the server to the client's xml data property.

simple as that. remember I am assuming that the owc version you are using has the xml data property.
Dec 8th, 2003, 05:49 PM
ddolheguy

MasterBlaster

Thank you so much for explaining this to me... I am still a little confused on the XML side of things as from my previous experience I am used to thinking that XML data means XML web files...

I will do some reading on the microsoft site and have a look at the demo code they have supplied...

Thanks heaps once again.
Dec 8th, 2003, 05:58 PM
MasterBlaster

No problem. The nice thing about this is you don't have to know anything about xml. All you are doing is passing a string from a web service or asp.net page to client side script and setting a property on the client. all of the xml reading and generation is done for you by the OWC.
Dec 9th, 2003, 05:47 PM
ddolheguy

Masterblaster...

Sorry to ask all these questions, but do you know if it's possible to use a straight SQL Query through an ADO connection with the Pivot Table example you have given me?

I have been looking at the example and setup an SQL Server 2000 with Analysis Services installed, but I am unable to generate a data cude through the web site provided.

I have setup a 'Sales' cube on the FoodMart 2000 database and when using the Analysis Manager and processing the cube I receive an 'unspecified error' when I try to browse the data cube. So I am guessing this maybe related to my problem...

Sorry to hit you with all this stuff, but initially I would like to make this as easy as possible.
Dec 9th, 2003, 05:55 PM
MasterBlaster

I don't think you can with the pivot table. I believe the you can using the owc spreadsheet though.
Dec 9th, 2003, 06:28 PM
ddolheguy

I don't suppose you know how too?? Or if you know of any examples???
Apr 3rd, 2006, 05:27 AM
brian84

Re: Help: Office Web Components (OWC)??

masterblaster:

do you know how to render a chart to owc chart in reporting service......
i manage to render a matrix to a pivot table only.....

thank you.....