Exporting Data to Excel using ADO.Net

If you want to export some data into excel in ASP.Net without having Excel on your server a good way to do it is it use a GridView and ADO.Net to do this. There are a few little tricks/snags you can quickly hit, so I’m going to show a few I’ve found.