Export to Excel

hi Mariyappan...

this  code  may  be  usefule  for  u
------------------------------------------------------------------code start-----------------------------------------
 HtmlForm htmlfrom = new HtmlForm();
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        tbl.Parent.Controls.Add(htmlfrom);
        htmlfrom.Controls.Add(tbl);
        htmlWrite.BeginRender();
        htmlfrom.RenderControl(htmlWrite);
        htmlWrite.BeginRender();
        Response.Clear();
        Response.Buffer = true;
        Response.ContentType = "application/vnd.ms-excel";
        Response.Charset = "";

        Response.AppendHeader("Content-Disposition", "attachment; filename=" + name + ".xls");
        Response.Write(stringWrite.ToString());
        Response.End();
------------------------------------------------------------------code end-----------------------------------------
Ritesh Diyawar

Hi,

you can try this Excel .NET library.

Here is a code snippet how to export DataGrid to Excel in Excel ASP.NET application:

// Get DataTable that DataGrid is bound to.
var dataTable = (DataTable)dataGrid.DataSource;

// Create new ExcelFile.
var ef = new ExcelFile();
// Add new worksheet to the file.
var ws = ef.Worksheets.Add(dataTable.TableName);
// Insert the data from DataTable to the worksheet starting at cell "A1".
ws.InsertDataTable(dataTable, "A1", true);

// Stream file to browser.
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=Employee.xls");
ef.SaveXls(Response.OutputStream);
Response.End();