convert fro datagridview to excel without for loop

Question

Hi I got a problem conversion was done but i have 5078 rows in datagridview so it takes 5 minutes to convert it into excel in windows Application.I did the code using for loop .Plz anybody help me Thanks & Regards sireesha

Amit Singh · Answer

Hey  refer this link 1.http://stackoverflow.com/questions/11742446/what-is-the-fastest-way-to-export-datagridview-rows-to-excel-or-into-an-sql-serv 2.http://www.c-sharpcorner.com/UploadFile/c5c6e2/export-datagridview-data-to-excel-in-C-Sharp-without-saving-to-fi/

Chandu Kumawat · Answer

http://www.c-sharpcorner.com/UploadFile/c5c6e2/export-datagridview-data-to-excel-in-C-Sharp-without-saving-to-fi/ http://www.aspdotnet-suresh.com/2014/12/export-datagridview-data-to-excel-in-csharp-windows-application-vb-net.html http://www.aspsnippets.com/Articles/Export-Windows-Forms-DataGridView-to-Excel-using-C-and-VBNet.aspx