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