export 한글깨질때

GridView 값을 엑셀로 다운로드 하려고 하는데 한글이 깨질때 하는법

 

아래와 같이 빨간색 2줄을 추가하면 Excel 로 다운로드할때 안깨진다.

       protected void ImageButton1_Click(object sender, ImageClickEventArgs e)

        {

                Response.Clear();

                Response.Charset = "UTF-8";

                Response.ContentEncoding = System.Text.Encoding.Default;

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

                Response.ContentType = "application/vnd.xls";

 

                System.IO.StringWriter         stringWriter = new System.IO.StringWriter();

                System.Web.UI.HtmlTextWriter   htmlWriter   = new HtmlTextWriter(stringWriter);

 

                GridView1.RenderControl(htmlWriter);

                Response.Write(stringWriter.ToString());

                Response.End();

        }