ASP.NET: Export a DataTable to Excel (WebProNews)
ASP.NET: Export a DataTable to Excel (WebProNews)
Back in February I wrote a post on how to export DataTables to XML and Excel and I still get a lot of search engine traffic to that post. People have been asking me to simplify the example and only concentrate on the Excel export, so that’s what I will do now. All spreadsheet applications (Excel, Calc etc.) understand semicolon separated files natively, so everyone can use this