用DataGrid生成Excel（总结）

来源：互联网发布：数据库er图与逻辑设计编辑：程序博客网时间：2024/06/05 10:58

public static void ExportExcelFile(System.Data.DataTable myTable)
        {
            if(myTable != null)
            {
                System.Web.UI.WebControls.DataGrid dgExport = new System.Web.UI.WebControls.DataGrid();
                dgExport.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(dgExport_ItemDataBound);
                System.Web.HttpContext curContext = System.Web.HttpContext.Current;
                curContext.Response.Clear();
                curContext.Response.Buffer= true;
                curContext.Response.Charset="GB2312";
                curContext.Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls");
                curContext.Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
                curContext.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
                System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
                System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
                System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
                dgExport.DataSource = myTable;
                dgExport.DataBind();
                dgExport.RenderControl(oHtmlTextWriter);
                curContext.Response.Write(oStringWriter.ToString());
                curContext.Response.End();
            }
        }
        private static void dgExport_ItemDataBound(object sender,System.Web.UI.WebControls.DataGridItemEventArgs e)
        {
            e.Item.Cells[1].Attributes.Add("style","vnd.ms-excel.numberformat:@"); //规定单元格类型去掉Excel中的科学计数法
            e.Item.Cells[3].Attributes.Add("style","vnd.ms-excel.numberformat:@");
            e.Item.Cells[5].Attributes.Add("style","vnd.ms-excel.numberformat:@");
        }