I have multiple SPGridViews on a page. I would like to export them all to one Excel document, each SPGridView on its own tab. Is this possible?
This link is a great start but does not solve my tab issue.
You can write your own custom export logic by using the COM Interop libraries. The class is
Tabs are Worksheet objects. The Excel document is the Workbook object.
Here's the link to the class library on MSDN: