马光军--------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 马光军 阅读(2185) 评论(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和;去掉 不过 这种形式的用这种方法导出的很不理想的啊  回复  更多评论
  


只有注册用户登录后才能发表评论。


网站导航: