Export SPGridView to Excel tabs

Question

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.

Answer 1

You can write your own custom export logic by using the COM Interop libraries. The class is Microsoft.Office.Interop.Excel. You probably have to download the MSO Interop pack unless you already have it. Just make sure to get the right Interop libraries for the version of Excel you're targeting.

Tabs are Worksheet objects. The Excel document is the Workbook object.

Here's the link to the class library on MSDN:

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel%28v=office.14%29.aspx

Answer 2

I decided to go the OpenXML route.