export database data into excel file in C# windows form

Question

How to export database data into excel file using C# windows form application? Thanks Regards R.Divya

Laxmikant · Answer

you can use Microsoft.Interop.Office.Excel to export to excel sheets. It allows you to format like backcolor font of cells formula for more info http://dotnetmentors.com/c-sharp/how-to-export-sql-data-to-excel-using-microsoft-office-interop.aspx

Rajesh Singh · Answer

Hi Please refer this. http://csharp.net-informations.com/excel/csharp-excel-export.htm/ http://www.codeproject.com/Questions/596938/HowplustoplusExportplusDatabaseplustableplusdatapl

Ravi Patel · Answer

Hi check this http://csharp.net-informations.com/excel/csharp-excel-export.htm https://www.youtube.com/watch?v=WcIkjudRORw