Mehmet AYDIN

Datatabledaki bilgileri aşağıdaki metodu kullanarak excele export edebilirsiniz. Dataset için de yapılması gerekenler aynıdır. Sadece datatable yerine bind edilen dataset olmalıdır.

public static void ExportDatatableToExcel(DataTable dtt, string filename)

{

try

{

HttpResponse Response = HttpContext.Current.Response;

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=" + filename + "\"");

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

DataGrid myDataGrid = new DataGrid();

myDataGrid.DataSource = dtt;

myDataGrid.DataBind();

myDataGrid.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

}

catch (Exception ex)

{

//Exception...

}

}