How do I create an Excel .xlsx file on-the-fly on ASP.NET Webforms site?

asp.net excel file-generation
chester89 picture chester89 · Nov 17, 2009 · Viewed 9.6k times · Source

I need to export timetable from the database to Excel file on-the-fly on ASP.NET WebForms site.
When user clicks "Export to Excel" link, he gets this file generated. I don't want to generate it explicitly and store on a server to provide download-on-a-demand, because then it'll be hundreds of files. I have all the data to do it, so the question is only about what approach to use.
One of my colleagues done this before in a very ugly way - he created separate web page, pushed all the data needed for export to a StringBuilder instance, then wrote all its contents to Response object, and added an appropriate headers to make it look like Excel file. All this work is 300 loc done in Page_Load event handler.
And our server hasn't Excel installed - yet another tricky thing.
Any suggestions? Thanks in advance

Answer

Joe Erickson picture Joe Erickson · Nov 21, 2009

SpreadsheetGear for .NET makes this easy to do.

You can see a number of live samples on our Excel Reporting Samples page here and download the free trial here.

Disclaimer: I own SpreadsheetGear LLC

Related questions

Export DataTable to Excel File

I have a DataTable with 30+ columns and 6500+ rows.I need to dump the whole DataTable values into an Excel file.Can anyone please help with the C# code.I need each column value to be in a cell.To be …

Read More
Import and Export Excel - What is the best library?

In one of our ASP.NET applications in C#, we take a certain data collection (SubSonic collection) and export it to Excel. We also want to import Excel files in a specific format. I'm looking for a library I can …

Read More
EPPlus number format

I have an Excel sheet generated with Epplus, I am experiencing some pain points and I wish to be directed by someone who have solved a similar challenge. I need to apply number formatting to a double value and I …

Read More