<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="http://www.w3.org/1999/xhtml"><headid="Head1"runat="server"><metahttp-equiv="Content-Type"content="text/html; charset=utf-8"/><linkhref="/CSS/Balance.css"rel="stylesheet"/><title></title><scriptrunat="server">PRotectedvoidwriteXls(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="+Title+".xls");
Response.Write(printHid.Value);
Response.End();
}</script></head><body><formid="form1"runat="server"><asp:HiddenFieldID="printHid"runat="server"/>
<asp:button runat="server" ID="ButtonExport" Text="生成excel" OnClientClick="getHtmlValue()" OnClick="writeXls" />
<scripttype="text/javascript">functiongetHtmltoValue() {
document.getElementById("<%=printHid.ClientID%>").value=document.getElementById("printDiv").innerHTML;
}</script><div id="printDiv">
<table>.......</table>
</div>
</form></body><html>