jsp 导出 excel

 jsp  页面生成表 怎么 导出excel 的形式 ？？  急用 啊  谢谢诶 各位 大侠啊 ！！  如果 有程序 可以给俺发到[email protected]

解决方案 »

  1.   

    就这个静态的例子  只要能在 JSP 中可以用就 OK 了 啊   可以给高分啊 呵呵 !!<table id="tableExcel" width="100%" border="1" cellspacing="0" cellpadding="0"> 
        <tr> 
            <td colspan="5" align="center">WEB页面导出为EXCEL文档的方法</td> 
        </tr> 
        <tr> 
            <td>列标题1</td> 
            <td>列标题2</td> 
            <td>列标题3</td> 
            <td>列标题4</td> 
            <td>列标题5</td> 
        </tr> 
        <tr> 
            <td>aaa</td> 
            <td>bbb</td> 
            <td>ccc</td> 
            <td>ddd</td> 
            <td>eee</td> 
        </tr> 
        <tr> 
            <td>AAA</td> 
            <td>BBB</td> 
            <td>CCC</td> 
            <td>DDD</td> 
            <td>EEE</td> 
        </tr> 
        <tr> 
            <td>FFF</td> 
            <td>GGG</td> 
            <td>HHH</td> 
            <td>III</td> 
            <td>JJJ</td> 
        </tr>  
    </table> 
      

  2.   


    <%@ page language="java" pageEncoding="GBK"%>
    <%response.setContentType("application/vnd.ms-excel");
    response.addHeader("Content-Disposition", "attachment; filename=abc.xls");%>
    <html xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns="http://www.w3.org/TR/REC-html40"><head>
    <meta http-equiv=Content-Type content="text/html; charset=GBK">
    <meta name=ProgId content=Excel.Sheet>
    <meta name=Generator content="Microsoft Excel 11">
    <!--[if gte mso 9]><xml>
     <x:ExcelWorkbook>
      <x:ExcelWorksheets>
       <x:ExcelWorksheet>
        <x:Name>Sheet1</x:Name>
        <x:WorksheetOptions>
         <x:DefaultRowHeight>285</x:DefaultRowHeight>
         <x:Selected/>
         <x:Panes>
          <x:Pane>
           <x:Number>3</x:Number>
           <x:ActiveRow>2</x:ActiveRow>
           <x:ActiveCol>1</x:ActiveCol>
          </x:Pane>
         </x:Panes>
         <x:ProtectContents>False</x:ProtectContents>
         <x:ProtectObjects>False</x:ProtectObjects>
         <x:ProtectScenarios>False</x:ProtectScenarios>
        </x:WorksheetOptions>
       </x:ExcelWorksheet>
      </x:ExcelWorksheets>
      <x:WindowHeight>9090</x:WindowHeight>
      <x:WindowWidth>11715</x:WindowWidth>
      <x:WindowTopX>240</x:WindowTopX>
      <x:WindowTopY>90</x:WindowTopY>
      <x:ProtectStructure>False</x:ProtectStructure>
      <x:ProtectWindows>False</x:ProtectWindows>
     </x:ExcelWorkbook>
    </xml><![endif]-->
    </head>
    <body>
    <table border="1" cellspacing="1" cellpadding="1">  
         <tr><td colspan="5" align="center">WEB页面导出为EXCEL文档的方法</td></tr>
         <tr>
             <td>列标题1</td>
             <td>列标题2</td>
             <td>列标题3</td>
             <td>列标题4</td>
             <td>列标题5</td>
         </tr>
         <tr>
             <td>aaa</td>
             <td>bbb</td>
             <td>ccc</td>
             <td>ddd</td>
             <td>eee</td>
         </tr>
         <tr>
             <td>AAA</td>
             <td>BBB</td>
             <td>CCC</td>
             <td>DDD</td>
             <td>EEE</td>
         </tr>
         <tr>
             <td>FFF</td>
             <td>GGG</td>
             <td>HHH</td>
             <td>III</td>
             <td>JJJ</td>
         </tr>
    </table>
    </body>
    </html>
      

  3.   

    你给我回的帖子 我看到了 非常感谢 但是我想添加一个 按钮 最好用javascript 控制的 你可以帮忙 吗 ？ 很感谢 啊
      

  4.   

    你给我回的帖子 我看到了 非常感谢 但是我想添加一个 按钮 最好用javascript 控制的 你可以帮忙 吗 ？ 很感谢 啊
      

  5.   

    DownXLS.jsp<%@ page language="java" pageEncoding="GBK"%>
    <%
    response.setContentType("application/vnd.ms-excel");
    response.addHeader("Content-Disposition", "attachment; filename=abc.xls");
    request.setCharacterEncoding("GBK");
    String body = request.getParameter("body");
    %>
    <html xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns="http://www.w3.org/TR/REC-html40"><head>
    <meta http-equiv=Content-Type content="text/html; charset=GBK">
    <meta name=ProgId content=Excel.Sheet>
    <meta name=Generator content="Microsoft Excel 11">
    <!--[if gte mso 9]><xml>
     <x:ExcelWorkbook>
      <x:ExcelWorksheets>
       <x:ExcelWorksheet>
        <x:Name>Sheet1</x:Name>
        <x:WorksheetOptions>
         <x:DefaultRowHeight>285</x:DefaultRowHeight>
         <x:Selected/>
         <x:Panes>
          <x:Pane>
           <x:Number>3</x:Number>
           <x:ActiveRow>2</x:ActiveRow>
           <x:ActiveCol>1</x:ActiveCol>
          </x:Pane>
         </x:Panes>
         <x:ProtectContents>False</x:ProtectContents>
         <x:ProtectObjects>False</x:ProtectObjects>
         <x:ProtectScenarios>False</x:ProtectScenarios>
        </x:WorksheetOptions>
       </x:ExcelWorksheet>
      </x:ExcelWorksheets>
      <x:WindowHeight>9090</x:WindowHeight>
      <x:WindowWidth>11715</x:WindowWidth>
      <x:WindowTopX>240</x:WindowTopX>
      <x:WindowTopY>90</x:WindowTopY>
      <x:ProtectStructure>False</x:ProtectStructure>
      <x:ProtectWindows>False</x:ProtectWindows>
     </x:ExcelWorkbook>
    </xml><![endif]-->
    </head>
    <body>
    <table border="1" cellspacing="1" cellpadding="1">
    <% out.print(body); %>
    </table>
    </body>
    </html>
    ------------------------test.htm<html>
    <head>
    <meta http-equiv=Content-Type content="text/html; charset=GBK">
    </head>
    <body> 
    <form id="frm1" action="DownXLS.jsp" target="_blank" style="margin:0;padding:0;" method="POST">
    <input type="hidden" name="body" value="" />
    </form>
    <script type="text/javascript">
    function downXLS() {
        // 把表格内容用表单 POST 到 DownXLS.jsp
    var tab = document.getElementById("tab1");
    var frm = document.getElementById("frm1");
    frm.body.value = tab.innerHTML;
    frm.submit();
    }
    </script>
    <table id="tab1" border="1" cellspacing="1" cellpadding="1">  
         <tr><td colspan="5" align="center">WEB页面导出为EXCEL文档的方法 </td></tr>  
         <tr>  
             <td>列标题1 </td>  
             <td>列标题2 </td>  
             <td>列标题3 </td>  
             <td>列标题4 </td>  
             <td>列标题5 </td>  
         </tr>  
         <tr>  
             <td>aaa </td>  
             <td>bbb </td>  
             <td>ccc </td>
             <td>ddd </td>
             <td>eee </td>
         </tr>
         <tr>
             <td>AAA </td>
             <td>BBB </td>
             <td>CCC </td>
             <td>DDD </td>
             <td>EEE </td>
         </tr>
         <tr>
             <td>FFF </td>
             <td>GGG </td>
             <td>HHH </td>
             <td>III </td>
             <td>JJJ </td>
         </tr>
    </table>
    <input type="button" value="down" onclick="javascript: downXLS();" />
    </body>
    </html>