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.CommandText,connection); dataAdapter.Fill(dataSet); DataTablet=dataSet.Tables[0]; //exportdatatabletoexcel Workbookbook= new Workbook(); Worksheetsheet=book.Worksheets[0]; sheet.InsertDataTable(t, true ,1,1); 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 Tp · 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/

writing data to a excel sheet and download using C#

Answers (4)