馬光軍--------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">
                             項(xiàng)目
                          
          </td>
                      
          </tr>
                      
          <tr align="center" class="table_2">
                          
          <td align="center">
                              
          <input name="classId" value="8913" type="radio" />
                          
          </td>
                          
          <td>
                              
          &nbsp;
                              
          <span>項(xiàng)目</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>開(kāi)行貸款</span>
                          
          </td>
                      
          </tr>
                      
          <tr align="center" class="table_1">
                          
          <td align="center">
                              
          <input name="classId" value="001" type="radio" />
                          
          </td>
                          
          <td>
                              
          &nbsp;
                              
          <span>市本級(jí)財(cái)政</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
                      //指定頁(yè)面區(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>
          通過(guò)以上的代碼,就能實(shí)現(xiàn)jsp中table內(nèi)容導(dǎo)出到word或excel
          posted on 2008-12-02 20:12 馬光軍 閱讀(2186) 評(píng)論(2)  編輯  收藏

          Feedback

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

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


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


          網(wǎng)站導(dǎo)航:
           
          主站蜘蛛池模板: 区。| 成都市| 黑河市| 金溪县| 柏乡县| 安吉县| 弋阳县| 武冈市| 湖南省| 衡山县| 黑龙江省| 霍林郭勒市| 武穴市| 集安市| 门源| 公安县| 长春市| 民乐县| 宿迁市| 织金县| 密云县| 安丘市| 香港 | 石泉县| 蚌埠市| 哈密市| 洪雅县| 宁明县| 高雄市| 鹤山市| 望谟县| 家居| 吉木乃县| 伊川县| 榕江县| 宜城市| 肇州县| 唐山市| 潞西市| 九江县| 德惠市|