2015年6月10日 星期三

ASP.NET GridView匯出Excel並解決亂碼問題

ASP.NET 將GridView內的資料匯出成Excel檔
---
看了上面這篇後,總算解決了問題點
如code:重點在這一行了!!
  1. Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>");
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. public partial class _Default : System.Web.UI.Page
  12. {
  13. protected void Button2_Click(object sender, EventArgs e)
  14. {
  15. Response.ClearContent();
  16. Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>");
  17. string excelFileName = "測試Excel檔案.xls";
  18. Response.AddHeader("content-disposition", "attachment;filename=" + Server.UrlEncode(excelFileName));
  19. Response.ContentType = "application/excel";
  20. System.IO.StringWriter stringWrite = new System.IO.StringWriter();
  21. System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
  22. GridView1.RenderControl(htmlWrite);
  23. Response.Write(stringWrite.ToString());
  24. Response.End();
  25. }
  26. public override void VerifyRenderingInServerForm(Control control)
  27. {
  28. // '處理'GridView' 的控制項 'GridView' 必須置於有 runat=server 的表單標記之中
  29. }
  30. }

沒有留言:

張貼留言