Reputation: 1409
I have an aspx page to display pages of report. The sections of report are each in a separate panel with navigation links. Say, clicking "Next" turns off current panel and turns on the "Next" page's panel.
I need to export this whole report to excel.
How to do it in asp.net ?
Can i get similar navigation and formatting in excel ?
EDIT I am using gridviews and .NET charting controls. (No 3rd party package outside .NET)
Upvotes: 1
Views: 853
Reputation: 40736
Since you are not mentioning that you are using a commercial Reporting package, I asume your reports are HTML pages. For such a scenario, I don't think that you have a direct path to Excel.
When I have to generate Microsoft Excel files, I usually choose one of these options:
Maybe this would be an option for you, too. Both packages are commercial, though.
Upvotes: 1