急啊 在线等啊 ~~~~ 导出问题

[duzidengdai521]

比如本来我的中文名是“列表.xls”，但是导出的excel中的标题和工作表名都成了：%e5%88%97%e8%a1%a8 1 .xls ，如果用英文名就没有问题，试了
HttpUtility.UrlEncode的方法也不行，在线等各位高手解答


代码如下：
public static void DtToExcel(DataTable dt, string FileName)
{
System.Web.HttpResponse httpResponse = System.Web.HttpContext.Current.Response;


httpResponse.Clear();
System.Web.UI.WebControls.GridView dataGrid = new System.Web.UI.WebControls.GridView();
dataGrid.DataSource = dt;
dataGrid.AllowPaging = false;
dataGrid.HeaderStyle.BackColor = System.Drawing.Color.White;
dataGrid.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
dataGrid.HeaderStyle.Font.Bold = true;
dataGrid.RowDataBound += new GridViewRowEventHandler(dataGrid_RowDataBound);
dataGrid.DataBind();

string aa = HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8);




httpResponse.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)); //filename="*.xls";
//httpResponse.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);


//httpResponse.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");




httpResponse.ContentType = "application/vnd.ms-excel";


System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
dataGrid.RenderControl(hw);
httpResponse.Write(tw.ToString());
httpResponse.End();

}

[nj_1st_excellence]

string aa = HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8);
httpResponse.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8));
-->
string aa = HttpUtility.UrlEncode(FileName, System.Text.Encoding.GB2312);
httpResponse.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.GB2312));

httpResponse.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文

试试

[nj_1st_excellence]

可以用下面2种简单的方法：

导出的类部分代码：
HttpResponse resp;
resp=Page.Response;
resp.ContentEncoding=System.Text.Encoding.Default;
resp.AppendHeader("Content-Disposition", "attachment;filename=报表.xls"); //这样写就出现了乱码


1.用System.Web.HttpUtility.UrlEncode或者Server.UrlEncode方法，不过要2个参数都写上：
System.Web.HttpUtility.UrlEncode("报表",System.Text.Encoding.UTF8)+".xls");

2.用HttpUtility.UrlPathEncode方法，只要写一个参数就可以了：
HttpUtility.UrlPathEncode("报表.xls")

最好就是这种了：
resp.AppendHeader("Content-Disposition", "attachment;filename="+HttpUtility.UrlPathEncode(FileName));

[duzidengdai521]

不行啊 标题还都是乱码啊 在线等。。。。。。。。。。。。。。。。。。。