网站首页  汉语字词  英语词汇  考试资料  写作素材  旧版资料

请输入您要查询的范文:

 

标题 asp.net中Table生成Excel表格的方法
范文
    本文实例讲述了asp.net中Table生成Excel表格的方法。分享给大家供大家参考。
    具体实现方法如下:
    代码如下:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
    <html xmlns="">
    <head id="Head1" runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link href="/Css/Balance.css" rel="stylesheet" />
    <title></title>
    <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=" + Title + ".xls");
    Response.Write(printHid.Value);
    Response.End();
    }
    </script>
    </head>
    <body>
    <form id="form1" runat="server">
    <asp:HiddenField ID="printHid" runat="server" />
    <button onclick="getHtmltoValue()" >生成excel</button>
    <script type="text/javascript">
    function getHtmltoValue() {
    document.getElementById("<%=printHid.ClientID%>").value = document.getElementById("printDiv").innerHTML;
     }
    </script>
    <table >
    .......
    </table>
    </form>
    </body>
    <html>
    希望本文所述对大家的asp.net程序设计有所帮助。
随便看

 

在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板,是学习及工作的有利工具。

 

Copyright © 2002-2024 cuapp.net All Rights Reserved
更新时间:2025/5/13 4:14:38