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 https://geeksarray.com/blog/how-to-export-sql-data-to-excel-using-microsoft-office-interop

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

Vishwakarma Vijay · Answer

This task can be easily achieved by using Spire.XLS. Here is the code snippet for your reference. //connect database OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = @ "Provider=" "Microsoft.Jet.OLEDB.4.0" ";Data Source=" "demo.mdb" ";User Id=;Password=" OleDbCommand command = new OleDbCommand(); command.CommandText = "select * from parts" ; DataSet dataSet = new System.Data.DataSet(); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(command.CommandText,connection); dataAdapter.Fill(dataSet); DataTable t = dataSet.Tables[0]; //export datatable to excel Workbook book = new Workbook(); Worksheet sheet = book.Worksheets[0]; sheet.InsertDataTable(t, true , 1, 1); book.SaveToFile( "insertTableToExcel.xls" ,ExcelVersion.Version97to2003); System.Diagnostics.Process.Start( "insertTableToExcel.xls" );