Hi, I am trying to export data to Excel. And I have GridView with paging enabled. When I download data using HtmlTextWriter it give download only to visible record in GridView. Can we download all the record in single excel file? And also downloaded-data should be with the same sorted state as sorted in GridView? Sanjeev

Sanjeev, Please follow the links on how to Export SPGridView to Excel spreadsheet Export GridView to Excel

Hi , Can you please sent me the code for exporting only the currently showing records while paging is enabled in grid view. Thanks in advance.