<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
script
runat
=
"server"
>
protected void writeXls(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel.numberformat:@";
this.EnableViewState = false;
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");//设置输出流为简体中文
Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls");
Response.Write(printHid.Value);
Response.End();
}
</
script
>
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
>无标题页</
title
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
asp:HiddenField
ID
=
"printHid"
runat
=
"server"
/>
<
div
id
=
"printDiv"
>
<
table
cellpadding
=
5
cellspacing
=
1
bgcolor
=
"#cccccc"
border
=
1
bordercolor
=
"#fffff"
>
<
tbody
>
<
tr
bgcolor
=
"#ffffff"
>
<
td
>1</
td
><
td
>2</
td
><
td
>3</
td
><
td
>4</
td
>
</
tr
>
<
tr
bgcolor
=
"#ffffff"
>
<
td
rowspan
=
2
>合并列</
td
>
<
td
colspan
=
3
>合并行</
td
>
</
tr
>
<
tr
bgcolor
=
"#ffffff"
>
<
td
colspan
=
3
>
<
table
width
=
"100%"
cellpadding
=
5
cellspacing
=
1
bgcolor
=
"#cccccc"
border
=
1
bordercolor
=
"#fffff"
><
tr
bgcolor
=
"#ffffff"
><
td
>111</
td
><
td
>222</
td
><
td
>333</
td
></
tr
></
table
>
</
td
>
</
tr
>
</
tbody
>
</
table
>
</
div
>
<
asp:Button
ID
=
"Button1"
runat
=
"server"
Text
=
"导出"
OnClientClick
=
"getHtmltoValue()"
OnClick
=
"writeXls"
/>
<
script
type
=
"text/javascript"
>
function getHtmltoValue(){
document.getElementById("<%=printHid.ClientID%>").value=document.getElementById("printDiv").innerHTML;
}
</
script
>
</
form
>
</
body
>
</
html
>