EXCEL导出中文识别的问题

 protected void btnOutput_Click(object sender, EventArgs e)
         {

                 OutPut("attachment;filename=OutPut.xls", "application/ms-excel");
                 this.Response.Write("<Script>alert(请查询!)</script>");
  
             不支持中文,会乱玛
                //string style = @"<style> .text { mso-number-format:/@; } </script> ";
       
                 //Response.ClearContent();

                 //Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");

                 //Response.ContentType = "application/excel";

                 //StringWriter sw = new StringWriter();

                 //HtmlTextWriter htw = new HtmlTextWriter(sw);

                 //GridView1.RenderControl(htw);

                 Style is added dynamically;

                 //Response.Write(style);

                 //Response.Write(sw.ToString());

                 //Response.End();

          }
       public override void VerifyRenderingInServerForm(Control control)
        {

        }

        private void OutPut(string fileType, string strType)
        {

        支持中文
            Response.Buffer = true;
            Response.Clear();
            Response.ClearContent();
            Response.ClearHeaders();
            Response.ContentType = "application nd.ms-excel";
            Response.Charset = "GB2312";
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.AddHeader("Content-Disposition", "attachment;filename=Plan.xls");
            Response.Write("<meta http-equiv=Content-Type content=text/html;charset=GB2312>");
            EnableViewState = false;
            StringWriter swOut = new StringWriter();
            HtmlTextWriter hTw = new HtmlTextWriter(swOut);
            GridView1.RenderControl(hTw);
            Response.Write(swOut.ToString());
            Response.End();

        }

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

天马行空8888

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值