GridView 轉EXCEL通用代碼

 

protected void BtnToExcel _Click(object sender, EventArgs e)

        {

            Response.Clear();

            Response.Buffer = true;

            Response.Charset = "GB2312";

            // 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！

            Response.AppendHeader("Content-Disposition", "attachment;filename= ExcelName .xls" );

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

            Response.ContentType = "application/ms-excel";// 设置输出文件类型为 excel 文件。

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

            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

            this.GridView1.RenderControl(oHtmlTextWriter);

            Response.Output.Write(oStringWriter.ToString());

            Response.Flush();

            Response.End();

        }

 public override void VerifyRenderingInServerForm(Control control)

        { }

或者寫成方法，方便調用(注意要把GridView放在Panel裡面)

 public void Export(System.Web.UI.WebControls.Panel panel, string fileName)

        {

            System.Web.HttpResponse httpResponse = Page.Response;

            httpResponse.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));

          httpResponse.Charset = "GB2312";

       // httpResponse.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

         httpResponse.ContentType = "application/ms-excel";

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

            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);

            panel.RenderControl(hw);

            string filePath = Server.MapPath("..") + fileName;

            System.IO.StreamWriter sw = System.IO.File.CreateText(filePath);

            sw.Write(tw.ToString());

            sw.Close();

            DownFile(httpResponse, fileName, filePath);

            httpResponse.End();

        }

        public bool DownFile(System.Web.HttpResponse Response, string fileName, string fullPath)

        {

            try

            {

                Response.ContentType = "application/octet-stream";

                Response.AppendHeader("Content-Disposition", "attachment;filename=" +

                    HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8) + ";charset=BIG5");

                System.IO.FileStream fs = System.IO.File.OpenRead(fullPath);

                long fLen = fs.Length;

                int size = 102400;  

                byte[] readData = new byte[size];  

                if (size > fLen) size = Convert.ToInt32(fLen);

                long fPos = 0;

                bool isEnd = false;

                while (!isEnd)

                {

                    if ((fPos + size) > fLen)

                    {

                        size = Convert.ToInt32(fLen - fPos);

                        readData = new byte[size];

                        isEnd = true;

                    }

                    fs.Read(readData, 0, size);   

                    Response.BinaryWrite(readData);

                    fPos += size;

                }

                fs.Close();

                System.IO.File.Delete(fullPath);

                return true;

            }

            catch

           {

                return false;

            }

        }