asp.net gridview到excel导出问题，代码调试没有错误，但没有得到导出的Excel文件 [英] asp.net gridview to excel export problem, Code debug with no errors but not getting exported Excel file

问题描述

代码调试没有错误，但是没有导出Excel文件.请帮助我

Code debug with no errors but not getting exported Excel file. Please Help Me

protected void btnExport_Click(object sender, EventArgs e)
{
            dgvCreditSettle.DataSource = Session["Grid"]; // For data binding to gridview
            dgvCreditSettle.DataBind();
            Response.Clear();
            Response.Buffer = true;
            Response.ClearContent();
            Response.ClearHeaders();
            Response.Charset = "";
            string FileName = "Credit Settle Details " + DateTime.Now.ToShortDateString() + ".xls";
            StringWriter strwritter = new StringWriter();
            HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
            Response.Cache.SetCacheability(HttpCacheability.NoCache);
            Response.ContentType = "application/vnd.ms-excel";
            Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
            dgvCreditSettle.GridLines = GridLines.Both;
            dgvCreditSettle.HeaderStyle.Font.Bold = true;
            dgvCreditSettle.RenderControl(htmltextwrtter);
            Response.Write(strwritter.ToString());
            Response.End(); 
}

   public override void VerifyRenderingInServerForm(Control control)
        {
            /* Confirms that an HtmlForm control is rendered for the specified ASP.NET
               server control at run time. */
        }

推荐答案

根据上面的讨论，我相信您没有使用更新面板".我发现您没有在导出之前绑定gridview.确保在导出之前加载所有数据并将其绑定到gridview.

As per the above discussion, I believe that you are not using the Update Panel. I figured it out that you are not binding gridview before export. Make sure you load all the data and bind it to gridview before export.

protected void btnExport_Click(object sender, EventArgs e)
{
  dgvCreditSettle.AllowPaging = false;
  //call your bind method here..
  LoadGridData();
  //now your export code here..
}

让我知道是否还有任何问题.

Let me know if still any issues.

这篇关于asp.net gridview到excel导出问题，代码调试没有错误，但没有得到导出的Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！