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

          BlogJava 聯系 聚合 管理
            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
          ="導出到EXCEL" />
                  
          </br>
                  
          <input type="button" onClick="return AllAreaWord();" value="導出到WORD" />
                  
          <script language="javascript">
                      
          function AutomateExcel(){
                          
          var elTable = document.getElementById("datatable"); //要導出的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;
                      }
                      
          //導出到word
                      //指定頁面區域內容導入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>
          通過以上的代碼,就能實現jsp中table內容導出到word或excel
          posted on 2008-12-02 20:12 馬光軍 閱讀(2186) 評論(2)  編輯  收藏

          Feedback

          # re: jsp中table內容導出到word或excel 2010-01-25 10:22 bulesky
          點擊按鈕沒反應,為什么?  回復  更多評論
            

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


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


          網站導航:
           
          主站蜘蛛池模板: 股票| 舞钢市| 油尖旺区| 洛宁县| 铁岭县| 梅州市| 达州市| 中阳县| 名山县| 肥西县| 岢岚县| 江川县| 吉水县| 永修县| 温宿县| 始兴县| 新密市| 唐河县| 乌恰县| 平乡县| 新丰县| 镇宁| 汶上县| 容城县| 宿松县| 永胜县| 依兰县| 荔波县| 建昌县| 新津县| 格尔木市| 大同市| 石棉县| 万宁市| 广汉市| 邵武市| 大丰市| 东兰县| 桂东县| 洪泽县| 基隆市|