Export data from Sql server to Excel sheets

also for windows application try this.
http://royalarun.blogspot.in/2012/01/export-datatable-to-excel-in-c-windows.html

If you try to save it in excel 2003, then u can only save upto 65536 rows.

So better change the xls to xlsx.
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=Reports.xls");

Change it to
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=Reports.xlsx");

Hi Santosh,

Thanks for your reply. I want to insert lac of data into one excel file. How to do that? I am just able to insert 65536 rows in a file, can we use another sheet for that I tried this as well but didn't workout for me. And its a window application. Any Idea?

look into this

http://www.c-sharpcorner.com/UploadFile/1a81c5/export-datatable-to-excel-with-formatting-in-C-Sharp/