writing data to a excel sheet and download using C#

sreedhar l

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

4 Replies

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

Alex Smith10y ago
actually you can also use a free .net Excel component to export data from datatable to Excel
//connectdatabase
OleDbConnectionconnection=newOleDbConnection();
connection.ConnectionString@"Provider=""Microsoft.Jet.OLEDB.4.0"";DataSource=""demo.mdb"";UserId=;Password="
OleDbCommandcommand=newOleDbCommand();
command.CommandText="select*fromparts";
DataSetdataSet=newSystem.Data.DataSet();
OleDbDataAdapterdataAdapter=newOleDbDataAdapter(command.CommandText,connection);
dataAdapter.Fill(dataSet);
DataTablet=dataSet.Tables[0];
//exportdatatabletoexcel
Workbookbook=newWorkbook();
Worksheetsheet=book.Worksheets[0];
sheet.InsertDataTable(t,true,1,1);
book.SaveToFile("insertTableToExcel.xls");
0
Bikesh Srivastava10y ago
Hi,
see on this link.
https://www.mindstick.com/Articles/853/writing-data-to-excel-sheet-using-c-sharp
0
Midhun Tp10y ago
Hi,

Please have a look at below article-
http://www.c-sharpcorner.com/UploadFile/deveshomar/exporting-datatable-to-excel-in-C-Sharp-using-interop/
0
Tapan Patel10y ago
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/
0