How to export gridview data to excel

Posted by Gsrinivas under C# on 9/7/2009 | Views : 6691 | Status : [Member] | Replies : 3
Hi,
please let me know how to export the gridview data to excel sheet.

Thanks & Regards
Srinivas




Responses

Posted by: Vuyiswamb on: 9/7/2009 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
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

Posted by: RtpHarry on: 9/8/2009 [Member] [MVP] Bronze

Up
0
Down
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

Posted by: Syedshakeer on: 9/8/2009 [Member] Starter

Up
0
Down
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

Login to post response