asp.net将数据导出到excel或word时为啥会是乱码
日期：2014-05-18 浏览次数：20428 次
asp.net将数据导出到excel或word时为什么会是乱码
需导入using System.Text;
在以下按钮单击事件中实现：
private void Button1_Click(object sender, System.EventArgs e)
{
Response.ContentType = "application/vnd.ms-excel ";
Response.AddHeader( "Content-Disposition ", "inline;filename= "
+ HttpUtility.UrlEncode( "下载文件.xls ",Encoding.UTF8 ) );
//如果输出为Word，修改为以下代码
//Response.ContentType = "application/ms-word "
//Response.AddHeader( "Content-Disposition ", "inline;filename=test.doc ")
StringBuilder sb=new StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
sb.Append( " <html> <body> ");
DataGrid1.RenderControl(hw);
sb.Append( " </body> </html> ");
Response.Write(sb.ToString());
Response.End();
}
请大家帮帮忙！！谢谢大家了
------解决方案--------------------
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312 ";
Response.ContentEncoding = System.Text.Encoding.GetEncoding( "GB2312 ");
string FileNames = DateTime.Now.ToString( "yyyyMMddHHmmss ") + ".xls ";
Response.AddHeader( "Content-Disposition ", "attachment;filename= " + FileNames);
Response.ContentType = "application/ms-excel ";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
这个是我的导出excel
------解决方案--------------------
Response.Charset = "GB2312 ";
Response.ContentEncoding = System.Text.Encoding.GetEncoding( "GB2312 ");
没错
再BS下楼主
搞定了也应该给分啊~！
最少证明下人家的劳动成果吧~！
需导入using System.Text;
在以下按钮单击事件中实现：
private void Button1_Click(object sender, System.EventArgs e)
{
Response.ContentType = "application/vnd.ms-excel ";
Response.AddHeader( "Content-Disposition ", "inline;filename= "
+ HttpUtility.UrlEncode( "下载文件.xls ",Encoding.UTF8 ) );
//如果输出为Word，修改为以下代码
//Response.ContentType = "application/ms-word "
//Response.AddHeader( "Content-Disposition ", "inline;filename=test.doc ")
StringBuilder sb=new StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
sb.Append( " <html> <body> ");
DataGrid1.RenderControl(hw);
sb.Append( " </body> </html> ");
Response.Write(sb.ToString());
Response.End();
}
请大家帮帮忙！！谢谢大家了
------解决方案--------------------
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312 ";
Response.ContentEncoding = System.Text.Encoding.GetEncoding( "GB2312 ");
string FileNames = DateTime.Now.ToString( "yyyyMMddHHmmss ") + ".xls ";
Response.AddHeader( "Content-Disposition ", "attachment;filename= " + FileNames);
Response.ContentType = "application/ms-excel ";
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
这个是我的导出excel
------解决方案--------------------
Response.Charset = "GB2312 ";
Response.ContentEncoding = System.Text.Encoding.GetEncoding( "GB2312 ");
没错
再BS下楼主
搞定了也应该给分啊~！
最少证明下人家的劳动成果吧~！
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
