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
Ïà¹ØÎĵµ£º
ÒѾ×öºÃµÄÒ»¸öJ2EEÏîÄ¿£¬ÏëÓ¦ÓÃflexÖеÄͼ±í£¬ËùÒÔÏÖÔÚµÄÊ×ÒªÎÊÌâ¾ÍÊÇÈçºÎ°ÑflexǶÈëµ½jspÖУ¬°´ÕÕÍøÉϽéÉܵĽâ¾ö·½°¸×öÁ˸öС²âÊÔ£º
<%@ taglib uri="FlexTagLib" prefix="mm"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
&nbs ......
¸÷ÀàÍøÒ³µ¯´°´úÂë±àд
¡¡
¾³£ÉÏÍøµÄÅóÓÑ¿ÉÄܻᵽ¹ýÕâÑùÒ»Ð©ÍøÕ¾£¬Ò»½øÈëÊ×Ò³Á¢¿Ì»áµ¯³öÒ»¸ö´°¿Ú£¬»òÕß°´Ò»¸öÁ¬½Ó»ò°´Å¥µ¯³ö£¬Í¨³£ÔÚÕâ¸ö´°¿ÚÀï»áÏÔʾһЩעÒâÊÂÏî¡¢°æÈ¨ÐÅÏ¢¡¢¾¯
¸æ¡¢»¶Ó¹â¹ËÖ®ÀàµÄ»°»òÕß×÷ÕßÏëÒªÌØ±ðÌáʾµÄÐÅÏ¢¡£ÆäÊµÖÆ×÷ÕâÑùµÄÒ³ÃæÐ§¹û·Ç³£µÄÈÝÒ×£¬Ö»ÒªÍù¸ÃÒ³ÃæµÄHTMLÀï¼ÓÈ뼸¶ÎJavascript´úÂë¼´¿ÉÊ ......
JSPÖеÄÌø×ª£º
(1). forward()·½·¨
ʹÓõ½javax.servlet.RequestDispatcherÀà
RequestDispatcher rd = getServletContext().getRequestDispatcher("url");
rd.forward(requestVar,requestVar); //´«µÝservletµÄÈë¿Ú²ÎÊý
/*forwardº ......
ѧϰJ2EE£¬±ØÐë¶ÔÏÂÃæµÄ¼¸¸ö¶ÔÏóÓкÜÉîµÄÀí½â
1¡¢request -> javax.servlet.http.HttpServletRequestµÄʵÀý
¸Ã¶ÔÏó·â×°ÁËÒ»´ÎÇëÇ󣬿ͻ§¶ËµÄÇëÇó²ÎÊý¶¼±»·â×°ÔڸöÔÏóÀï¡£ÕâÊÇÒ»¸ö³£ÓõĶÔÏ󣬻ñÈ¡¿Í»§¶ËÇëÇó²ÎÊý±ØÐëʹÓøöÔÏó¡£³£Óõķ½·¨ÓÐgetParameter(String pa ......