馬光軍--------BLOG

          BlogJava 聯(lián)系 聚合 管理
            1 Posts :: 25 Stories :: 5 Comments :: 0 Trackbacks
          <html>
              
          <head>
              
          <title>projectGovPlace_list.jsp</title>
                  
          <meta http-equiv="pragma" content="no-cache">
                  
          <meta http-equiv="cache-control" content="no-cache">
                  
          <meta http-equiv="expires" content="0">
                  
          <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
                  
          <meta http-equiv="description" content="This is my page">
                  
          <link href="css/strongpt.css" rel="stylesheet" type="text/css">
              
          </head>
              
          <body>
                  
          <table width="100%" border="0" align="center" cellPadding="0"
                      cellSpacing
          ="0" id="datatable">
                      
          <tr align="center">
                          
          <td width="4%" class="table_title">
                              #
                          
          </td>
                          
          <td width="14%" class="table_title">
                             項目
                          
          </td>
                      
          </tr>
                      
          <tr align="center" class="table_2">
                          
          <td align="center">
                              
          <input name="classId" value="8913" type="radio" />
                          
          </td>
                          
          <td>
                              
          &nbsp;
                              
          <span>項目</span>
                          
          </td>
                      
          </tr>
                      
          <tr align="center" class="table_1">
                          
          <td align="center">
                              
          <input name="classId" value="005" type="radio" />
                          
          </td>
                          
          <td>
                              
          &nbsp;
                              
          <span>其他</span>
                          
          </td>
                      
          </tr>
                      
          <tr align="center" class="table_2">
                          
          <td align="center">
                              
          <input name="classId" value="004" type="radio" />
                          
          </td>
                          
          <td>
                              
          &nbsp;
                              
          <span>單位自籌</span>
                          
          </td>
                      
          </tr>
                      
          <tr align="center" class="table_1">
                          
          <td align="center">
                              
          <input name="classId" value="003" type="radio" />
                          
          </td>
                          
          <td>
                              
          &nbsp;
                              
          <span>銀行貸款</span>
                          
          </td>
                      
          </tr>
                      
          <tr align="center" class="table_2">
                          
          <td align="center">
                              
          <input name="classId" value="002" type="radio" />
                          
          </td>
                          
          <td>
                              
          &nbsp;
                              
          <span>開行貸款</span>
                          
          </td>
                      
          </tr>
                      
          <tr align="center" class="table_1">
                          
          <td align="center">
                              
          <input name="classId" value="001" type="radio" />
                          
          </td>
                          
          <td>
                              
          &nbsp;
                              
          <span>市本級財政</span>
                          
          </td>
                      
          </tr>
                  
          </table>
                  
          <input type="button" onClick="return AutomateExcel();"
                      value
          ="導(dǎo)出到EXCEL" />
                  
          </br>
                  
          <input type="button" onClick="return AllAreaWord();" value="導(dǎo)出到WORD" />
                  
          <script language="javascript">
                      
          function AutomateExcel(){
                          
          var elTable = document.getElementById("datatable"); //要導(dǎo)出的table id。
                          var oRangeRef = document.body.createTextRange(); 
                          oRangeRef.moveToElementText(elTable); 
                          oRangeRef.execCommand(
          "Copy");
                          
          var appExcel = new ActiveXObject("Excel.Application");
                          appExcel.Workbooks.Add().Worksheets.Item(
          1).Paste(); 
                          appExcel.Visible 
          = true
                          appExcel 
          = null;
                      }
                      
          //導(dǎo)出到word
                      //指定頁面區(qū)域內(nèi)容導(dǎo)入Word
                      function AllAreaWord(){
                          
          var oWD = new ActiveXObject("Word.Application");
                          
          var oDC = oWD.Documents.Add("",0,1);
                          
          var orange =oDC.Range(0,1);
                          
          var elTable = document.getElementById("datatable"); 
                          
          var sel = document.body.createTextRange();
                          sel.moveToElementText(elTable);
                          
          //sel.select();
                          sel.execCommand("Copy");
                          orange.Paste();
                          oWD.Application.Visible 
          = true;
                          oWD 
          = null;
                      }
                  
          </script>
              
          </body>
          </html>
          通過以上的代碼,就能實現(xiàn)jsp中table內(nèi)容導(dǎo)出到word或excel
          posted on 2008-12-02 20:12 馬光軍 閱讀(2186) 評論(2)  編輯  收藏

          Feedback

          # re: jsp中table內(nèi)容導(dǎo)出到word或excel 2010-01-25 10:22 bulesky
          點擊按鈕沒反應(yīng),為什么?  回復(fù)  更多評論
            

          # re: jsp中table內(nèi)容導(dǎo)出到word或excel 2013-08-21 15:03 哇哇哇
          onClick="return AutomateExcel();"
          把return和;去掉 不過 這種形式的用這種方法導(dǎo)出的很不理想的啊  回復(fù)  更多評論
            


          只有注冊用戶登錄后才能發(fā)表評論。


          網(wǎng)站導(dǎo)航:
           
          主站蜘蛛池模板: 东阿县| 贵州省| 乌恰县| 阳春市| 台南县| 化德县| 宜城市| 蓬安县| 桃江县| 江都市| 马尔康县| 托里县| 资中县| 宿松县| 尼木县| 浦城县| 汉沽区| 山东省| 普洱| 会东县| 左权县| 怀化市| 镇宁| 山西省| 濮阳市| 防城港市| 同仁县| 镇沅| 古交市| 克拉玛依市| 英德市| 惠东县| 柘荣县| 湘阴县| 上犹县| 江西省| 平遥县| 得荣县| 海安县| 富平县| 晋江市|