How to export gridview data to excel

Good Day

In my Company we use Infragistics, Telerik and ComponentArt. Microsoft Controls dont have that capability and the user interface is not attractive. There are companies like those i provided above. They provide great controls to do this. I think you have to start looking at this. but there is a simple way to do it in a normal asp.net app like this

http://www.codeproject.com/KB/database/ExportDataToExcelUsingCS.aspx

http://www.codedigest.com/Articles/ASPNET/130_Export_to_Excel_in_ASPNet_20_%E2%80%93Gridview_to_Excel_DataTable_to_Excel.aspx

http://geekswithblogs.net/azamsharp/archive/2005/12/21/63843.aspx

http://www.c-sharpcorner.com/UploadFile/DipalChoksi/exportxl_asp2_dc11032006003657AM/exportxl_asp2_dc.aspx

Thank you for Posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Gsrinivas, if this helps please login to Mark As Answer. | Alert Moderator

Yeah as Vuyiswa says - commercial components are the best for office introp but it is possible to do it for free if you are on a budget.

Here are a couple more tutorials that explain free ways to export to xls, doc, csv, pdf:

http://www.aspsnippets.com/post/2009/06/19/Exporting-Multiple-GridViews-To-Excel-SpreadSheet-in-ASPNet.aspx

http://www.aspsnippets.com/post/2009/06/19/Exporting-Multiple-GridViews-To-Excel-SpreadSheet-in-ASPNet.aspx

Gsrinivas, if this helps please login to Mark As Answer. | Alert Moderator

Hi Srinivas,
Check the following link you will get exactly waht you want....
http://www.dotnetfunda.com/articles/article429-simplest-method-export-gridviewdata-to-excelsheet-using-aspnet.aspx

Syed Shakeer Hussain

Gsrinivas, if this helps please login to Mark As Answer. | Alert Moderator