Pivot tables in ASP.Net / C#

[Prasad Patil]

Hi,

I have created a report in excel, it uses Pivot tables.
The excel has two sheets
1: Pivot ( Contains the Pivot Table)
2: Data (Data Requred to populate the pivot table

I create an instance of Excel populate the data sheet and load excel in the
browser.

But i need to referesh the Pivot table withe the populated data on the
server before i render the excel sheet on the browser.

I am anot able to access the Pivot table in the excel sheet using ASP.Net / C#

Any links, suggestion in doing the same.

Cheers
Prasad