writing data to a excel sheet and download using C#

Question

How to write data into a excel sheet using datatable in c# using microsoft.interop excel and download that excel sheet.

Tapan Patel · Answer

Take a look at below article. It has all the details you may need. http://www.c-sharpcorner.com/article/exporting-datagrid-to-excel-in-wpf/

Alex Smith · Answer

actually you can also use a free .net Excel component to export data from datatable to Excel //connectdatabase OleDbConnectionconnection= new OleDbConnection(); connection.ConnectionString@ Provider= Microsoft.Jet.OLEDB.4.0 ;DataSource= demo.mdb ;UserId=;Password= OleDbCommandcommand= new OleDbCommand(); command.CommandText= select*fromparts ; DataSetdataSet= new System.Data.DataSet(); OleDbDataAdapterdataAdapter= new OleDbDataAdapter(command.CommandTextconnection); dataAdapter.Fill(dataSet); DataTablet=dataSet.Tables[0]; //exportdatatabletoexcel Workbookbook= new Workbook(); Worksheetsheet=book.Worksheets[0]; sheet.InsertDataTable(t true 11); book.SaveToFile( insertTableToExcel.xls );

Bikesh Srivastava · Answer

Hi see on this link. https://www.mindstick.com/Articles/853/writing-data-to-excel-sheet-using-c-sharp

Midhun T P · Answer

Hi Please have a look at below article- http://www.c-sharpcorner.com/UploadFile/deveshomar/exporting-datatable-to-excel-in-C-Sharp-using-interop/