I have developed some code that uses packaging to export gridview data to an Excel Spread Sheet. Using system.io.packaging allows the export to be accomplished without MS Excel being installed.
Follow the link below to see the code and view a live demo.
Participant
970 Points
270 Posts
Export Gridview Data to Excel
Oct 19, 2009 02:22 PM|JasonAlm|LINK
I have developed some code that uses packaging to export gridview data to an Excel Spread Sheet. Using system.io.packaging allows the export to be accomplished without MS Excel being installed.
Follow the link below to see the code and view a live demo.
http://almsnet.net/post/OOXml-Export-Gridview-to-Excel.aspx
Enjoy!!
NOTE: This is not a question but a statement. Just want to share with all others. Thanks
Export GridView to Excel Office Open Xml OoXml