C# 数据导出：DataTable到Excel的Web与WinForm实现

1.web

public void TableToExcel(System.Data.DataTable tb)
        {
            try
            {
                string Filename="person";
                System.Web.HttpContext context = System.Web.HttpContext.Current;

                if ((tb != null))
                {
                    context.Response.Clear();
                    context.Response.Charset = "GB2312";
                    context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
                    context.Response.ContentType = "application/ms-excel";
                    context.Response.AppendHeader("content-disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(Filename, System.Text.Encoding.GetEncoding("GB2312")) + ".xls\"");

                    System.Globalization.CultureInfo cult = new System.Globalization.CultureInfo("zh-CN", true);
                    StringWriter sw = new StringWriter(cult);
                    HtmlTextWriter htw = new HtmlTextWriter(sw);
                    DataGrid dgrid = new DataGrid();
                    dgrid.DataSource = tb.DefaultView;
                    dgrid.AllowPaging = false;
                    dgrid.DataBind();
                    htw.WriteLine("<meta http-equiv=\"Content-Type\" content=\"textml;charset=GB2312\">");
                    dgrid.RenderControl(htw);
                    context.Response.Write(sw.ToString());
                    context.Response.End();
                }
            }