调用DataTable2Excel()导出Excel时只弹出了div是咋回事

调用DataTable2Excel()导出Excel时只弹出了div是怎么回事？

C# code


public static void DataTable2Excel(System.Data.DataTable dtData, string name)
        {
            GridView dgExport = null;
            // 当前对话 
            System.Web.HttpContext curContext = System.Web.HttpContext.Current;
            // IO用于导出并返回excel文件 
            System.IO.StringWriter strWriter = null;
            System.Web.UI.HtmlTextWriter htmlWriter = null;

            if (dtData != null)
            {
                // 设置编码和附件格式 
                curContext.Response.ContentType = "application/vnd.ms-excel";
                curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
                curContext.Response.Charset = "UTF-8";
                string fileurl = System.Web.HttpUtility.UrlEncode(name) + DateTime.Now.ToString("yyyyMMddHHmm") + ".xlsx";
                curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileurl);

                // 导出excel文件 
                strWriter = new System.IO.StringWriter();
                htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);

                // 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid 
                dgExport = new GridView();

                dgExport.DataSource = dtData.DefaultView;
                dgExport.AllowPaging = false;
                dgExport.DataBind();

                // 返回客户端 
                dgExport.RenderControl(htmlWriter);
                curContext.Response.Write(strWriter.ToString());
                curContext.Response.End();                
            }
        }

使用DataTable2Excel(dt, "导出数据");调用

最后只弹出了一个div,Excel并未启动是怎么回事？

弹出的DIV如下：

------解决方案--------------------
你是怎么调用的》这样写是没有问题的

HTML code

<%@ Page Language="C#" EnableViewState="true" %>

<%@ Import Namespace="System.Xml" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">


  public System.Data.DataTable CreateDataTable()
  {
    System.Data.DataTable dataTable1 = new System.Data.DataTable("BlogUser");
    System.Data.DataRow dr;
    dataTable1.Columns.Add(new System.Data.DataColumn("Id", typeof(System.Int32)));
    dataTable1.Columns.Add(new System.Data.DataColumn("Title", typeof(System.String)));

    for (int i = 0; i < 8; i++)
    {
      dr = dataTable1.NewRow();
      dr[0] = i;
      dr[1] = "xxxxxxxxxxxxxxxxxxxxx" + i.ToString();
      dataTable1.Rows.Add(dr);
    }
    return dataTable1;
  }

  protected void Page_Load(object sender, EventArgs e)
  {
    if (!Page.IsPostBack)
    {

    }
  }


  public static void DataTable2Excel(System.Data.DataTable dtData, string name)
  {
    GridView dgExport = null;
    // 当前对话 
    System.Web.HttpContext curContext = System.Web.HttpContext.Current;
    // IO用于导出并返回excel文件 
    System.IO.StringWriter strWriter = null;
    System.Web.UI.HtmlTextWriter htmlWriter = null;

    if (dtData != null)
    {
      // 设置编码和附件格式 
      curContext.Response.ClearContent();
      curContext.Response.ContentType = "application/vnd.ms-excel";
      curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
      curContext.Response.Charset = "UTF-8";
      string fileurl = System.Web.HttpUtility.UrlEncode(name) + DateTime.Now.ToString("yyyyMMddHHmm") + ".xlsx";
      curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileurl);

      // 导出excel文件 
      strWriter = new System.IO.StringWriter();
      htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);

      // 为了解决dgData中可能进行了分页的情况，需要重新定义一个无分页的DataGrid 
      dgExport = new GridView();

      dgExport.DataSource = dtData.DefaultView;
      dgExport.AllowPaging = false;
      dgExport.DataBind();

      // 返回客户端 
      dgExport.RenderControl(htmlWriter);
      curContext.Response.Write(strWriter.ToString());
      curContext.Response.End();
    }
  }

  protected void Button1_Click(object sender, EventArgs e)
  {
    DataTable2Excel(CreateDataTable(), "xxx");
  }
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
  <title>无标题页</title>
</head>
<body>
  <form id="form1" runat="server">
  <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Style="height: 21px"
    Text="Button" />
  </form>
</body>
</html>

调用DataTable2Excel()导出Excel时只弹出了div是咋回事

相关推荐