export database data into excel file in C# windows form

Divya Sindhu

How to export database data into excel file using C# windows form application?

Thanks Regards

R.Divya

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmikant10y ago
Accepted 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
Vishwakarma Vijay5y ago
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");
Rajesh Singh10y ago
Hi
Please refer this.
http://csharp.net-informations.com/excel/csharp-excel-export.htm/
http://www.codeproject.com/Questions/596938/HowplustoplusExportplusDatabaseplustableplusdatapl
Ravi Patel10y ago
Hi,
check this
http://csharp.net-informations.com/excel/csharp-excel-export.htm
https://www.youtube.com/watch?v=WcIkjudRORw