Hello,
Using C# and OWC 11.0, I need to create an excel output with all Raw Data in one sheet. Using that data as the connection string, i need to create pivot tables in another worksheet. This excel sheet will be downloaded by the end user so they can change parameters in pivot table and get the report they need. Whenever the raw data is updated, the user will come to dashboard and get the new excel generated. I have the code for getting all the data in the data sheet. i need some pointers to create the pivot table on the 2nd work sheet.
Please advise- Desai