datatable导出execl乱码问题的解决方法与列名修改的方法

 

private void DataTable2Excel(System.Data.DataTable dtData)       
        ...{ 
            System.Web.UI.WebControls.DataGrid dgExport = null; 
            // 当前对话 
            System.Web.HttpContext curContext = System.Web.HttpContext.Current; 
            // IO用于导出并返回excel文件 
            System.IO.StringWriter strWriter = null; 
            System.Web.UI.HtmlTextWriter htmlWriter = null; 
            if (dtData != null)                
            ...{ 
                // 设置编码和附件格式 
//                curContext.Response.ContentType = "application/vnd.ms-excel"; 
//                curContext.Response.ContentEncoding =System.Text.Encoding.UTF8; 
//                curContext.Response.Charset = ""; 
                curContext.Response.Charset="utf-8"; 
                curContext.Response.AppendHeader("Content-Disposition","attachment;filename=ganbuxinxi.xls"); 
                curContext.Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");    
                curContext.Response.ContentType = "application/ms-excel"; 
                         
                // 导出excel文件 
                strWriter = new System.IO.StringWriter(); 
                htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter); 
         
                // 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid 
                dgExport = new System.Web.UI.WebControls.DataGrid(); 
                dgExport.DataSource = dtData.DefaultView; 
                dgExport.AllowPaging = false; 
                dgExport.DataBind(); 
         
                // 返回客户端 
                dgExport.RenderControl(htmlWriter);     
                curContext.Response.Write(strWriter.ToString()); 
                curContext.Response.End(); 
            } 
        } 

我的方法就是把上面注释的代码换成了它下面的

curContext.Response.Charset="utf-8";
    curContext.Response.AppendHeader("Content-Disposition","attachment;filename=ganbuxinxi.xls");
    curContext.Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");   
    curContext.Response.ContentType = "application/ms-excel";

还有人常会说我怎么改列名，其实改的方法也简单。就是在数据给datatable填充后用

dt.Columns["列名"].ColumnName="你想起的名称";

即可，例如下面的代码：

DataTable dt = new DataTable();
            execlcmd.Fill(dt);
            dt.Columns["mid"].ColumnName="会员编号";
            dt.Columns["name"].ColumnName="会员姓名";
            dt.Columns["cardrename"].ColumnName="职务";
            dt.Columns["jobtime"].ColumnName="任职时间";
            dt.Columns["deptid"].ColumnName="所属公会";