creating an Excel Worksheet in C#.NET

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).

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

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?

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.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");
            System.Diagnostics.Process.Start("insertTableToExcel.xls");
        }

hi follow below url

http://csharp.net-informations.com/excel/csharp-excel-export.htm