如何把html生成的table导出到Excel

[Dreamer9]

简单问题,table是由html生成的,如何把它导出到excel
(我已经知道怎么把DataSet导出到excel,但是这种方法只能导一个table,
而我由html生成的table其实是由几个table组成的,我想问怎么直接把html导出到Excel)
多谢,解决马上给分

[reaperwu]

1、用一个大的Table（runat="server"）包含所有的小Table
<table cellpadding="0" cellspacing="0" width="2048" id="table" runat="server">
<内容>
</table>
2、导出大的Table，Export(Page, table)

/// <summary>
/// 导出Excel
/// </summary>
/// <param name="page"></param>
/// <param name="control"></param>
public static void Export(Page page, Control control)
{
page.Response.Clear();
page.Response.Buffer= true;
page.Response.AppendHeader("Content-Disposition","Attachment;fileName=Export.xls");
page.Response.ContentType = "application/vnd.ms-excel";
page.Response.Charset = "";
page.Response.ContentEncoding = Encoding.Default;
page.EnableViewState = false;

StringWriter stringWriter = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
control.RenderControl(htmlTextWriter);
page.Response.Write(stringWriter.ToString());
page.Response.End();
}

[loveeqing]

up

[javaca88]

好啊
我再问一下:如何将导入EXCEL

[gsk99]

up

[Dreamer9]

to reaperwu(RQ)
问题是我的table是程序生成的啊,程序生成的html组成了table,在把html加在PlaceHolder上的

[reaperwu]

to Dreamer9(梦想者)
那你可不可以在PlaceHolder外面放一个Table

或者试试Export(Page，PlaceHolder)

[liujiayu10]

<%Response.ContentType = "application/vnd.ms-excel"%>

页顶加入上面这句就行了

[Dreamer9]

to reaperwu(RQ)
Table (runat="server")外面放不了PlaceHolder啊

有没有什么方法直接把html的内容导出到Excel啊,应该有这种方法的?

[Dreamer9]

liujiayu10(持续学习)

不懂,有没有例子可看啊

[reaperwu]

<table cellpadding="5" cellspacing="0" width="100%" border="1" id="table" runat="server">
<tr>
<td>
<asp:PlaceHolder id="PlaceHolder1" runat="server"></asp:PlaceHolder>
</td>
</table>