1
private void toExcel(DataTable tb) 2

{ 3
System.Web.UI.WebControls.DataGrid dgrid = null; 4
System.Web.HttpContext context = System.Web.HttpContext.Current; 5
System.IO.StringWriter strOur = null; 6
System.Web.UI.HtmlTextWriter htmlWriter = null; 7

if ((tb != null))
{ 8
context.Response.ContentType = "application/vnd.ms-excel "; 9
context.Response.ContentEncoding = System.Text.Encoding.UTF8; 10
context.Response.Charset = " "; 11
12
strOur = new IO.StringWriter(); 13
htmlWriter = new System.Web.UI.HtmlTextWriter(strOur); 14
dgrid = new DataGrid(); 15
dgrid.DataSource = tb.DefaultView; 16
dgrid.AllowPaging = false; 17
dgrid.DataBind(); 18
19
dgrid.RenderControl(htmlWriter); 20
context.Response.Write(strOur.ToString); 21
context.Response.End(); 22
} 23
}
浙公网安备 33010602011771号