ASP.Net web server control that generates HTML and Excel

Question

I am developing a web application that contains a great deal of reporting. The reports are fairly basic, but some have multiple datasets or embedded charts. One of the key requirements is that each report can be exported to Excel. The Excel version of the report is disconnected and should look the same (or very similar) to the web report. That includes formmating of values, cell styles, number of rows/columns, charts, etc.

The problem I've encountered is that the ASP.Net reporting tools I've looked at do a great job in creating the report, but the export to Excel is not as robust as I'd like. The ASP.Net spreadsheet tools do a great job generating an Excel sheet, but they don't offer a way to view the information in a browser without downloading them locally and viewing them in Excel.

Any suggestions? Thanks!

Answer 1

MS Reporting Services that comes with SQL server produces pretty high fidelity Excel spreadsheets.

Otherwise you could do this with MOSS Enterprise using Excel Services and the Excel Viewer web part.

Answer 2

Infragistics has some fairly robust web controls, one of them is a grid that can export to Excel. The Excel export component allows you to format the results, add images and other stuff, so it should do what you are after.

The only problem with Infragistics is that their API is extremely ... what is the word ... cumbersome? So it takes some work to get used to and often much code to get things done properly. But the end result is good.