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();       }