求查询数据库数据导出到EXCEL方法，不要下面这种方法，方法要有引用集什么的

Question

不要这个代码，数据少了我就日了弹出框一闪而过 
Response.Clear();
            Response.AddHeader("Content-Type ", "application/octet-stream ");
            Response.AddHeader("content-disposition", "attachment;filename=AJ_JC.xls");
            Response.Charset = "UTF-8";
            Response.ContentType = "application/ms-excel";
            System.IO.StringWriter stringWrite = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);            GridView1.AllowPaging = false;
            GridView1.AllowSorting = false;
            Bind1();
            //GridView1.Columns[0].Visible = false;            GridView1.RenderControl(htmlWrite);            Response.Write(stringWrite.ToString());
            Response.End();
路过的大哥哥大姐姐们帮帮忙

Answer 1

怎么 会 一闪而过？ 我一直用的很好啊 看看我的整合的代码 屏蔽了 各种乱码 
Response.Clear();
Response.Buffer = true;
Response.Charset = "gb2312";
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment;filename=Stock List(" + DateTime.Now.ToString("yyyy-MM-dd") + ").xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
repeater.RenderControl(oHtmlTextWriter);
Response.Write("<meta http-equiv=Content-Type content=text/html;charset=GB2312>");
Response.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
这个 repeater 是你的 数据绑定控件

Answer 2

貌似 你的 木有this.EnableViewState = false; 这一句哎。。

Answer 3

一条 也是可以的我 到给 你看， 截个图不知道 你看到图不？
I:\QQ截图1.png
I:\QQ截图2.png

Answer 4

        /// 把DataSet导出到Excel文件,并带表头
        /// </summary>
        /// <param name="title">表头</param>
        /// <param name="_caption">标题</param>
        /// <param name="ds">源数据DataSet</param>
        /// <param name="cols">导出的列</param>
        /// <param name="FileName">导出的文件名</param>
        public static void ExportDataSetToExcelWithTitle(string title,string[] _caption, DataSet ds, string[] cols, string FileName)
        {
            HttpResponse resp;
            resp = HttpContext.Current.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
            resp.Charset = "UTF-8";            string colHeaders = "", ls_item = "";
            int i = 0;            DataTable dt = ds.Tables[0];
            DataRow[] myRow = dt.Select("");            resp.ContentType = "application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword            resp.Write(title +"\n");            for (i = 0; i < _caption.Length - 1; i++)
                colHeaders += _caption[i] + "\t";            colHeaders += _caption[i] + "\n";            resp.Write(colHeaders);            foreach (DataRow row in myRow)
            {
                for (i = 0; i < cols.Length - 1; i++)
                {
                    if (dt.Columns.Contains(cols[i]))
                        ls_item += row[cols[i]].ToString().Replace("\t", "").Replace("\n", "").Replace("\r", "") + "\t";
                }                ls_item += row[cols[i]].ToString().Replace("\t", "").Replace("\n", "").Replace("\r", "") + "\n";
 
                resp.Write(ls_item);
                ls_item = "";
            }
          
            resp.End();
        }
    }

Answer 5

net 导出excel在360浏览器下出现一闪而过  网上 我也查了 你用的 哪些浏览器，是不是过滤掉了， 或者什么软件 给屏蔽了

Answer 6

遇到个这个问题，当时在受信站点的“自定义级别”中“启动文件下载”和“启动文件下载的自动提示”
然后在文件夹选项中添加.XLS的文件类型，解决问题
IE中 工具internet选项-》安全-》自定义级别-》下载-》文件下载，
把这个启用就OK了。