How to Export sharepoint 2010 SPGridView data to excel. My data with tree strutured is avilable in spgridview.

Note: if any of the column value contains multiple value then i need to convert into new value for each item.

2 Answers 2


I reckon it should work similar as the asp.net Gridview export to excel. See this : http://www.fivenumber.com/export-spgridview-to-excel-spreadsheet-in-sharepoint-2007/ Its for 2007 but should be ok for 2010 also see http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html Hope this helps Cheres

  • yeah i am using above code only but i need to expand collapse section in excel sheet. like excel grouping or sharepoint list grouping. Oct 14, 2011 at 10:29

Please check this post - http://www.fivenumber.com/export-spgridview-to-excel-spreadsheet-in-sharepoint-2007/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.