creating an Excel Worksheet in C#.NET

Question

I want to create an Excel worksheet with the details from a database and the important thing is the column names of the database should be displayed in the column headers of the excel sheet. for instance column names of an excel sheet is like this A B C D but for my program it must want to be displayed like UserName Location etc. please help me sir to get it done.

Darren Kang · Answer

Hi check out this solution for importing DataTable instance into an Excel sheet with C# code . In short it uses this .NET library to process excel files and you call a direct API ( InsertDataTable ) on the required worksheet. Also notice the InsertDataTableOptions.ColumnHeaders property will indicate if the columns names will be imported as a header row (first row).

Sagar Pardeshi · Answer

this for web app http://www.codedigest.com/Articles/ASPNET/400_ImportUpload_Excel_Sheet_data_to_Sql_Server_in_C__and_AspNet.aspx

darjeam nh · Answer

This .NET component definitely can be used in web application have you add Spire.Excell.dll as a reference in your object before debugging the sample code?

Arun Kumar Radhakrishnan · Answer

(Export Data for database to Excel in C#)its not working sir

Arun Kumar Radhakrishnan · Answer

Thank you sir but these codes are for windows application but i want to export data to an excel sheet in web application i am very sorry that i didnt mention it in the question

darjeam nh · Answer

hello refer this article - Export Data for database to Excel in C# private void button1_Click(object sender EventArgs e) { //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.CommandTextconnection); 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); System.Diagnostics.Process.Start(insertTableToExcel.xls); }

Sagar Pardeshi · Answer

hi follow below url http://csharp.net-informations.com/excel/csharp-excel-export.htm