Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 0 down vote accepted

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

share|improve this answer
    
yeah i am using above code only but i need to expand collapse section in excel sheet. like excel grouping or sharepoint list grouping. –  My Name is Suresh Oct 14 '11 at 10:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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