OWC Spreadsheet as PivotTable.DataSource?

[Brent Stroh]

I've been able to track down any number of examples of using a spreadsheet
as the datasource for a chart, but I'm attempting to create a disconnected
PivotTable in an ASP.NET app (C#). I quickly realized I couldn't just add
the data to the PivotTable, since I couldn't find Rows, SetData, etc, like
I've used with charts and spreadsheets.

To further complicate things, I've put the spreadsheet and pivottable
controls on the web page. When the user fills in search criteria and hits
the button on the form, the spreadsheet data is loaded by copying the
XMLData from an equivalent spreadsheet built on the server.

With web clients that will not have access to the database, how can I embed
a PivotTable in a web page so the data will ride along?

Thanks!

 

[Alvin Bruney - MVP ASP.NET]

The black book discusses a technique that goes something like this
Response.Write("<embed chart clsid">);
Response.Write("chart1.Setdata('http://some.url.com');

very, very roughly

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET