• λ我爱Aspx >> Asp.Net >> 将ASP.NET页面内的数据导出到Excel 或 Word中

    • 将ASP.NET页面内的数据导出到Excel 或 Word中

  • :aspxer  Դ:5iaspx  :2007-8-1 13:15:18  ؼ:.net,asp.net,asp,数据

  • 在以下按钮单击事件中实现：

    private void btnMIME_Click(object sender, System.EventArgs e)

    {

    BindData();

    Response.ContentType = "application/vnd.ms-excel";

    Response.AddHeader("Content-Disposition", "inline;filename="

    + HttpUtility.UrlEncode("下载文件.xls",Encoding.UTF8 ) );

    //如果输出为Word，修改为以下代码

    //Response.ContentType = "application/ms-word"

    //Response.AddHeader("Content-Disposition", "inline;filename=test.doc")

    StringBuilder sb=new StringBuilder();

    System.IO.StringWriter sw = new System.IO.StringWriter(sb);

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

    sb.Append("<html><body>");

    dgShow.RenderControl(hw);

    sb.Append("</body></html>");

    Response.Write(sb.ToString());

    Response.End();

    }

    注：1.若DataGrid中有按钮列，则在导出前应先将其隐藏.

    2.若DataGrid有分页，而又要打印所有数据的话就应先取消分页.

    http://pyt5208.cnblogs.com/archive/2006/07/10/447048.html

    Ҷƪл˵?
  • һƪ设置上传文件的最大大小
    һƪSQL server 2005中的DATENAME函数