.xls .txt文件生成下载

来源:互联网 发布:遥感卫星数据 编辑:程序博客网 时间:2024/04/23 19:50
 //在点击事件里完成  .txt文件

 Response.Clear();
            Response.ClearHeaders();
            Response.BufferOutput = true;
            //Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            Response.ContentEncoding = System.Text.Encoding.UTF8;

            string filename = "IP21实时数据库" + Label1.Text + "标签点";
            HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;   filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".txt");
            // Response.Write(GetTagsString("\r\n"));
            DataTable b = new DataTable();
            b = (DataTable)Session["aa"];
            string value = "";
            for (int i = 0; i < b.Rows.Count; i++)
            {
                value += b.Rows[i][0].ToString() + "\r\n";

            }

            Response.Write(value);
            Response.Flush();
            Response.End();

 //在点击事件里完成  .xls文件

 Response.Clear();
        Response.Charset = "utf-8";
        string filename = "IP21实时数据库"+Label1 .Text +"";
        HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;   filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8) + ".xls");
        //Response.AddHeader("content-disposition", "attachment;filename=IP21实时数据库" + Label1.Text + ".xls");
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

        ExtraGridView1.AllowPaging = false;
        DATA();
        ExtraGridView1.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());
        Response.End();
        ExtraGridView1.AllowPaging = true;
        DATA();

如果报“ ExtraGridView”的控件“ExtraGridView1”必须放在具有 runat=server 的窗体标记

则 在后台文件中重载VerifyRenderingInServerForm方法,如:
public   override   void   VerifyRenderingInServerForm(Control   control)
{
          //base.VerifyRenderingInServerForm(control);
}