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.

iPhone is an exmaple of great design

This may be a little late, and has certainly missed thebig iPhone debate, but having just received my iPhone this week, I have to say, what a beatifully designed system they have.

Yes, system. Sure the phone looks great... but it is a joy to use. It is a great piece of user interface design - which is why it's relevant to this blog. Apple has really understood the needs of the phone user and delivered something that is very considerate to this.

Congratulations Apple in California! You've really raised the bar in the mobile phone world.

ASP.NET / VB.NET developer

Blue Hat is looking for a new .NET developer. With experience in VB.NET 2.0/3.5 and, ideally, MCPD or MCSD certified! A great company to work for that will support your development, it's ambitious, is growing and has great clients!

What else can I say! Have a look: Blue Hat Jobs

The Silverlight again....

My recent posts do seem to all be on a similar theme, but I returned to the office this afternoon to be met with the exciting news of SilverLight 2.0's arrival. We've been looking forward to this for sometime!!!

For those interested, take a look at the Microsoft Silverlight Tools Beta 1 for Visual Studio 2008

Silverlight on it's way

A little late on the posting, but just had a look though Scott Gu's blog about Silverlight 2.0... Really looking forward to seeing this in action (and ready for us .NET developers to use)!

Scott Gu Looking forward to Silverlight 2.0