Rendering EXCEL pivot kind of report using C#

[Guest]

Has any body tried using pivot tables in C#
I am trying to achieve pivot table functionality ( Rendering Row fields / Column Fields / Data fields ) in C# with Excel 2003. I have complete data in one dataset and i would like to render it on Excel similar to pivot table

Is anybody have idea how Excel renders and presents data in the form of pivot table?Are is there any articles which explain the rendering logic of pivot tables

Thanks in advanc
Ram

 

[Charles Williams]

Not sure what you mean by "rendering".

assuming that what you want to do is to create an Excel pivot table you need
to look at the excel object model: either use the pivot table wizard or use
ADO to create a pivot cache.
I have not done this from C# but its fairly straightforward from VBA.

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

Has any body tried using pivot tables in C#?
I am trying to achieve pivot table functionality ( Rendering Row fields /

Column Fields / Data fields ) in C# with Excel 2003. I have complete data in
one dataset and i would like to render it on Excel similar to pivot table.

Is anybody have idea how Excel renders and presents data in the form of

pivot table?Are is there any articles which explain the rendering logic of
pivot tables?