Adding pivot tables to AxSpreadsheet

[maggie.q.li]

Hi,

I have a winform application which has a AxSpreadsheet component, and
within this spreadsheet I need to display pivot tables. Does anyone
know how to do that?

Thanks,
Maggie

 

[Alvin Bruney - MVP ASP.NET]

The pivot table can take a range as a datasource. Simply set the active
pivot table to a range on the spreadsheet and the data will show up. For a
code snippet, you can google this newsgroup.

--
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

 

[maggie.q.li]

How do you add a pivot table to an axspreadsheet at the first place?

I"m using C#, and have datatable (converted to ADODB.Recordset) as the
pivot table's datasource. I know in VB you add the pivot table by
something like PivotCached?? I don't see any similiar properties in C#
for the AxSpreadSheet object.

Thanks,
Maggie