jspÖÐʹÓÃEXCEL×é¼þ½«±í¸ñµ¼³öΪEXCELÎļþ
´ËÖÖ·½·¨Ê¹ÓÃexcelµÄ×é¼þ£¬ÒªÇó¿Í»§¶Ë±ØÐë×°ÓÐexcel³ÌÐò¡£·½·¨Êǽ«±í¸ñÖеÄÿ¸ötd±êÇ©µÄÄÚÈÝÈ¡³ö£¬×÷ΪexcelÎļþÖÐÒ»¸öµ¥Ôª¸ñµÄÄÚÈÝ¡£
1¡¢ÔÚÍøÒ³ÖÐÌí¼Ójava½Å±¾
function AutomateExcel(tableid,unusecolumn)
{
// »ñÈ¡excel×é¼þ
var oXL = new ActiveXObject("Excel.Application");
//´´½¨¹¤×÷±¡
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var table = document.getElementById(tableid);
var hang = table.rows.length;
var lie = table.rows(0).cells.length;
for (i=0;i<hang;i++)
{
for (j=0;j<lie-unusecolumn;j++)
{
oSheet.Cells(i+1,j+1).value = table.rows(i).cells(j).innerText;
}
}
oXL.Visible = true;
oXL.UserControl = true;
}
2¡¢Ôö¼Óµ¼³ö°´Å¥
<input class="Noprint" type="Button" onclick="AutomateExcel('ordertable','0');" value="µ¼³ö">
AutomateExcelº¯ÊýµÄµÚÒ»¸ö²ÎÊýÊÇÒªµ¼³öµÄ±í¸ñµÄID£¬µÚ¶þ¸ö²ÎÊý±íʾµ¼³öʱ±í¸ñĩβҪºöÂÔµÄÁÐÊý£¬Èç²»ÐèÒªºöÂÔ£¬ÇëÉèÖÃΪ‘0’
3¡¢OK£¡
Ïà¹ØÎĵµ£º
JSP£¨Java Server Page£©
JSPÊÇ·þÎñÆ÷¶ËÔËÐеÄÒ³Ãæ£¬JSP±¾¾ÍÊÇÒ»¸öÎĵµ£¬Ëû²»½ö¿ÉÒÔ°üº¬¾²Ì¬µÄHTML´úÂ룬Ҳ¿ÉÒÔ°üº¬¶¯Ì¬µÄJAVA´úÂ룬·þÎñÆ÷ÈÝÆ÷¿ÉÒÔ½«JSPת»»³ÉServlet·¢²¼£¬²¢½ÓÊÜÇëÇó¡£
JspÎļþÖ»Ðè·ÅÔÚÓ¦ÓÃÎļþϾͿÉÒÔÁË¡£
JSPÀý×Ó£º
<html>
<head><title>time</title></head>
& ......
ÓÉÓÚÒª×öÉÏ´« ¾ÍÕÒÁ˸öÀý×Ó Áô×Ųο¼
ÉÏ´«£ºÐèÒªsmartupload×é¼þ
import com.jspsmart.upload.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
/**
* ÉÏ´«¹«¹²Àà,¶ÔSmartUpload½øÐÐÁË·â×°
* ......
servletÖлñµÃÏîÄ¿¾ø¶Ô·¾¶
String filePath=this.getServletConfig().getServletContext().getRealPath("/");
¸ùĿ¼Ëù¶ÔÓ¦µÄ¾ø¶Ô·¾¶:request.getServletPath();
ÎļþµÄ¾ø¶Ô·¾¶ :request.getSession().getServletContext().getRealPath(request.getRequestURI())
µ±Ç°webÓ¦Óõľø¶Ô·¾¶ :servletConfig.getServletCo ......
¼¸ºõËùÓеÄWeb¿ª·¢ÓïÑÔ¶¼Ö§³ÖSession¹¦ÄÜ£¬ServletÒ²²»ÀýÍâ¡£ Servlet/JSPÖеÄSession¹¦ÄÜÊÇͨ¹ý×÷ÓÃÓò(scope)Õâ¸ö¸ÅÄîÀ´ÊµÏֵġ£
×÷ÓÃÓò·ÖΪËÄÖÖ£¬·Ö±ðΪ£º
page
ÔÚµ±Ç°Ò³ÃæÓÐЧ(½öÓÃÓÚJSPÖÐ)
request
ÔÚµ±Ç°ÇëÇóÖÐÓÐЧ
session
ÔÚµ±Ç°»á»°ÖÐÓÐЧ
application
ÔÚËùÓÐÓ¦ÓóÌÐòÖÐÓÐЧ
ÊDz»ÊÇ¿´²»Ì«Ã÷°×£¿pageÒòΪ½ ......
±¾Àý×ÓÔÚWindows+Tomcat6(weblogic9.2)+jdk1.6ÏÂÔËÐС£
1£©°²×°ºÃjdk1.6£¬È»ºó°²×°tomcat6.
2£©ÔÚtomcatĿ¼µÄconfĿ¼Ï£¬ÐÞ¸Äserver.xml¡£
±¾Àý×ÓÊÇĬÈÏÅäÖÃÔËÐÐÔÚÐéÄâĿ¼Ï£¬,²¢ÇÒÉÏ´«»ù׼Ŀ¼µÄÎïÀí·¾¶ÔÚµ±Ç°Ó¦ÓÃÏ¡£Çë¸ù¾ÝµÚ3µã£¬ÔÚ¶ÔÓ¦µÄhost½ÚµãÉϼÓÈëÀ¶É«²¿·Ö´úÂë¡£
1£©Èç¹ûÓ¦Óò¿ÊðÔÚÍøÕ¾¸ùĿ¼ ......