Matt Berseth supplies an awesome way to export to excel with pretty much no hassle whatsoever
Just add in his class and call it withing as event like this
GridViewExportUtil.Export("save_as_this.xls", this.GridViewName);
And that is it, nothing else is necessary. And the code is very simple and easy to follow.
Here is the link to Matt's site with more details on it.