C# .NET - How to export data to excell sheet in Console Application and send it as a Mail attachment

Asked By Ajay Paritala on 19-Feb-13 04:23 PM

Hi,

How to export data to Excel sheet in a Console Application and send it as a Email attachment?

I'm facing problem here. I work on Web application to export data to excel sheet but same commands are not accepting in Console application but my requirement is to use console application. Can someone guide me about how to export data from data table to excel sheet in a console application

 Thank You....

White Ashlin replied to Ajay Paritala on 19-Feb-13 08:25 PM
I only know how to export data to excel sheet, below article can help you much:
http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/

or go codeplex source code page, this library can help you export data to excel, pdf,word, html,xml, csv,ms access etc from database, listview and command:
http://exportdata.codeplex.com/