table表格导入到excel

//光看别人写的是没有用的，自己复制上去试下就知道这些东西怎么用了。很简单

protected void DataToExcel()//Excel输出
      {
          Response.Clear();
          Response.Buffer = true;
          Response.Charset = "GB2312";
          //下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开
          //filename=SearchResult.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc .xls .txt .htm
          Response.AppendHeader("Content-Disposition", "attachment;filename=SearchResult.xls");
          Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
          //Response.ContentType指定文件类型 可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 或其他浏览器可直接支持文档
          Response.ContentType = "application/ms-excel";
          this.EnableViewState = false;
          // 定义一个输入流
          System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
          System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
           this.tableName.RenderControl(oHtmlTextWriter);
          //this 表示输出本页，tableName表示表格的名字，你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件
          Response.Write(oStringWriter.ToString());
          Response.End();
      }

protected void DataToTxt()//文本输出到客户端
      {
          Response.Clear();
          Response.Buffer = true;
          Response.Charset = "GB2312";
          Response.AppendHeader("Content-Disposition", "attachment;filename=SearchResult.txt");
          Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
          Response.ContentType = "application/ms-txt";
          this.EnableViewState = false;
          string wLine;
          System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
          wLine = "输出的文本：" + DateTime.Now.ToString() + "/r/n";
          oStringWriter.Write(wLine);//把字符串写到输入流
          Response.Write(oStringWriter.ToString ());
          Response.End();
      }