jspÖÐtableµ¼³ÉexclÎļþ
ÏîÄ¿ÒªÇ󽫺ǫ́Êý¾Ý½øÐÐÏÔʾ£¨ÏÔʾҪÇ󲿷ÖÄÚÈݽøÐÐÁÐÏîºÏ²¢£©£¬ÔÚ¶ÔÏÔʾµÄÊý¾Ý½øÐе¼³ö³Éexcel
ʵÏÖ¹ý³Ì
1¡¢²éѯºÍµ¼³öµÄjspÒ³Ãæ ¹Ø¼ü´úÂë
<script language=javascript>
function exportExcel(){
/****ʵÏÖ·½·¨Ò»
<%-- var curTbl = document.getElementById("techQueryTab"); --%>
<%-- var oXL = new ActiveXObject("Excel.Application"); --%>
<%-- //´´½¨AX¶ÔÏóexcel --%>
<%-- var oWB = oXL.Workbooks.Add(); --%>
<%-- //»ñÈ¡workbook¶ÔÏó --%>
<%-- var oSheet = oWB.ActiveSheet; --%>
<%-- //¼¤»îµ±Ç°sheet --%>
<%-- var sel = document.body.createTextRange(); --%>
<%-- sel.moveToElementText(curTbl); --%>
<%-- //°Ñ±í¸ñÖеÄÄÚÈÝÒƵ½TextRangeÖÐ --%>
<%-- sel.select(); --%>
<%-- //È«Ñ¡TextRangeÖÐÄÚÈÝ --%>
<%-- sel.execCommand("Copy"); --%>
<%-- //¸´ÖÆTextRangeÖÐÄÚÈÝ --%>
<%-- oSheet.Paste(); --%>
<%-- //Õ³Ìùµ½»î¶¯µÄEXCELÖÐ --%>
<%-- oXL.Visible = true; --%>
<%-- //ÉèÖÃexcel¿É¼ûÊôÐÔ --%>
***ʵÏÖ·½·¨Ò»*/
//***ʵÏÖ·½·¨¶þ ͨ¹ýform½øÐÐÌá½»ÖÁhtml2excel.jsp
var myform=document.createElement('form');
myform.action='common/html2excel.jsp';
myform.method='post';
myform.target='_blank';
var html=document.createElement('<input type="hidden" name="html">');
html.value=document.getElementById('table-container').innerHTML;
myform.appendChild(html);
document.appendChild(myform);
myform.submit();
}
//ʵÏÖ·½·¨¶þ½áβ
</script>
¡£¡£¡£
//¹¹Ôìtable²¿·Ö
<div id='table-container'>
<table id="techQueryTab" width="100%" borde
Ïà¹ØÎĵµ£º
Ò» ¡¢ ÓÃstruts2±êÇ©µÄ<s:selectÀ´ÏÔʾ
<s:select cssStyle="width: 84%" list="#application.officeList" headerKey="" headerValue="--ÇëÑ¡Ôñ--" listKey="#this.value" listValue="#this.key+'.'+#this.value" name="entity.officeName" value="entity.officeName"/>
ÆäÖÐ
1¡¢listÊǽÓÊÕjavaÀà»òÕßÔÚÆô¶¯Ê± ......
String url="http://www.baidu.com";
ActionForward gotourl = new ActionForward(url);
gotourl.setPath(url);
gotourl.setRedirect(true);
return gotourl;
1.RequestDispatcher.forward()
¡¡¡¡ ÊÇÔÚ·þÎñÆ÷¶ËÆð×÷ÓÃ,µ±Ê¹ÓÃforward()ʱ,Servlet engine´ ......
ѧϰJ2EE£¬±ØÐë¶ÔÏÂÃæµÄ¼¸¸ö¶ÔÏóÓкÜÉîµÄÀí½â
1¡¢request -> javax.servlet.http.HttpServletRequestµÄʵÀý
¸Ã¶ÔÏó·â×°ÁËÒ»´ÎÇëÇ󣬿ͻ§¶ËµÄÇëÇó²ÎÊý¶¼±»·â×°ÔڸöÔÏóÀï¡£ÕâÊÇÒ»¸ö³£ÓõĶÔÏ󣬻ñÈ¡¿Í»§¶ËÇëÇó²ÎÊý±ØÐëʹÓøöÔÏó¡£³£Óõķ½·¨ÓÐgetParameter(String pa ......