0

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.

Improve this question

2 Answers 2

Reset to default
0

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

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

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

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.