Export the Grid Data to Excel

Question

Hi Can anyone help me with the custom code for exporting grid data to excel.

Sanjeeb Lenka · Answer

then you have to sort the grid before export it. or you can do it at the time of selecting form database using Order By ascending or descending

Ravi Shekhar · Answer

Hi For sorting data you can use order by in your sql query. then fire your export with sorted datatable. Regards Ravi

Vignesh Kumar · Answer

hi sanjeeb since i am new to this i am not able to sort this. Can you help me with the code.

Sanjeeb Lenka · Answer

check this link here step by step is there http://www.aspdotnet-suresh.com/2011/04/how-to-export-gridview-data-to-excel-or.html

Riyaz Akhtar · Answer

Check below link: http://www.codeproject.com/Tips/477436/Export-Gridview-Data-to-Excel-in-ASP-NET