Ever have to export data from a GridView to an Excel spreadsheet?

While the overall process is fairly straightforward, there are some caveats involved when paging and column sorting are enabled. A search on the Web will lead you to several results on how to proceed (some with good but unproven ideas, many with frustrating deadends) - the best discussion/example, in my opinion, can be found here.

Note that while this is a great implementation, it didn't exactly cover my specific assignment's needs (my details/solution will be discussed in a future article on my News page). Otherwise, enjoy till the next one!