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
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.