zl程序教程

您现在的位置是:首页 >  工具

当前栏目

asp.net导出Excel显示中文乱码的解决方法

2023-06-13 09:14:47 时间

复制代码代码如下:


 protectedvoidbtnExcel_Click(objectsender,EventArgse)
   {
       List<bUFlow.Model.orderhistory>orderlist=dal.GetOrderList2("");
       stringfilename="3g流量网龄升级计划用户表";
       stringname1=filename;
       stringbname=Common.MyRequest.GetBrowserName().ToLower();
       if(bname.Contains("firefox"))
       {
       }
       elseif(bname.Contains("ie"))
       {
           filename=HttpUtility.UrlEncode(filename,System.Text.Encoding.UTF8);
       }
       else
       {
           filename=HttpUtility.UrlEncode(filename,System.Text.Encoding.UTF8);
       }

       HttpResponseresp=System.Web.HttpContext.Current.Response;
       resp.Charset="utf-8";
       resp.Clear();
       resp.AppendHeader("Content-Disposition","attachment;filename="+filename+".xls");
       resp.ContentEncoding=System.Text.Encoding.UTF8;

       resp.ContentType="application/ms-excel";
       stringstyle="<metahttp-equiv=\"content-type\"content=\"application/ms-excel;charset=utf-8\"/>"+"<style>.table{font:9ptTahoma,Verdana;color:#000000;text-align:center; background-color:#8ECBE8; }.tabletd{text-align:center;height:21px;background-color:#EFF6FF;}.tableth{font:9ptTahoma,Verdana;color:#000000;font-weight:bold;background-color:#8ECBEA;height:25px; text-align:center;padding-left:10px;}</style>";
       resp.Write(style);
       //resp.Write(ExportTable(list));
       resp.Write("<tableclass="table"><tr><th>"+"手机"+"</th><th>"+"渠道"+"</th><th>"+"时间"+"</th></tr>");
       //dbVideoList=(List<subShiyongModel>)Session["dbVideoList"];
       foreach(bUFlow.Model.orderhistorymodelinorderlist)
       {
           resp.Write("<tr><td>"+model.phone+"</td>");
           resp.Write("<td>"+model.qudao+"</td>");
           resp.Write("<td>"+model.tm+"</td>");
           resp.Write("</tr>");
       }
       resp.Write("<table>");

       resp.Flush();
       resp.End();
   }

 


 需要注意的是编码的问题,在输出的时候,最好加上以下语句:
 复制代码代码如下:

<metahttp-equiv="content-type"content="application/ms-excel;charset=gb2312"/>