asp.net中Table生成Excel表格的方法
本文实例讲述了asp.net中Table生成Excel表格的方法。分享给大家供大家参考。
具体实现方法如下:
<!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//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(objectsender,EventArgse) { 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"/> <buttononclick="getHtmltoValue()">生成excel</button> <scripttype="text/javascript"> functiongetHtmltoValue(){ document.getElementById("<%=printHid.ClientID%>").value=document.getElementById("printDiv").innerHTML; } </script>
<table> ....... </table> </form> </body> <html>