Exporting data to excel using VB.NET/ASP.NET

This post is going to be a little code heavy, but I do like to share a useful function every so often. Here I've picked up on the good work done at http://www.dotnetspider.com/qa/Question1653.aspx and taken it a little step further to simplify it use.

This consists three functions. The first of which you would call from your ASP.NET code if you have a DataTable that you would like to be available to users as to Save or Open in Excel:

The vb.net export code

Here's the code: Feel free to ask any questions find faults or heap praise upon it! :) Export-to-excel-from-vb.net.txt.

Read on for how to use.

Exporting to Excel from a datatable

This is the simpler one. Just call the sub DownloadDataTable pass in a DataTable and a Filename to save as.

Exporting to Excel from a datagrid

This isn't actually much more complex to use to be honest... Just call the sub DownloadDataGrid, but this time pass in a DataGrid and a Filename to save as.