I have an SQL database with data stored in it but I'd like to create reports that will allow the user to enter two dates and return the data in an excel spreadsheet.

Not sure how to accomplish this in .net with C#. I've created PDF reports using ITextSharp but don't think it is the same for excel.

Any help to point me in the right direction or advice would be great.

Thank you


If it is just standard data that you want to export to Excel, have you considered just exporting the data to a CSV file which the user can then open in Excel.

Alternatively, if you want to create sophisticated Excel files then I can recommend Aspose Cells which I have used to create some very complex Excel spreadsheets from ASP.NET.


Thank you, I think exporting to a CSV file will be easier.