将HTML里的Table控件导出到Excel以后,表格线如何显示?
我的问题是这样的:
我在后台.cs类里面,得到了一个table的innerhtml,想把这个table导出到Excel,我自己试了下面的代码以后,
结果表格线就是不显示,搜索了好久没找到解决办法,请大侠指教一下。
protected void To_Excel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=SearchResult.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
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);
test.RenderControl(oHtmlTextWriter); //test就是table所在的Div的ID
//this 表示输出本页,tableName表示表格的名字,你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件
Response.Write(oStringWriter.ToString());
Response.End();
}