馬光軍--------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)航:
           
          主站蜘蛛池模板: 壤塘县| 靖宇县| 绥化市| 永春县| 潞西市| 廉江市| 吉隆县| 清远市| 徐水县| 庄浪县| 连平县| 东辽县| 健康| 项城市| 宝应县| 榆林市| 延津县| 宕昌县| 嘉兴市| 合川市| 海兴县| 盱眙县| 罗江县| 高尔夫| 漠河县| 武义县| 灵川县| 平远县| 康定县| 资源县| 隆昌县| 株洲市| 红原县| 富平县| 桂平市| 宁德市| 乌什县| 台江县| 桐城市| 刚察县| 怀化市|