Export Excel file more than three columns

Question

Hi can any one help me.i want to export data in excel sheet.my data base table have more than three columns.but when i export data it will be in three column of excel sheet in compressed form how can i increase the columns.

 

 

Answer 1

Hi

Try the below links

http://www.aspsnippets.com/Articles/Export-GridView-to-Excel-in-ASPNet-with-Formatting-using-C-and-VBNet.aspx

http://csharp.net-informations.com/excel/csharp-excel-export.htm

http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/