Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

javaʹÓÃPOI²Ù×÷Excel±¨±í

HSSFWorkbook API£ºhttp://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html
office°ì¹«Èí¼þµÄʹÓÃʹµÃ¿ª·¢ÆóÒµ°ì¹«ÏµÍ³ÖУ¬³£³£Óпͻ§ÕâÑù×ÓÒªÇó£ºÄãÒª°ÑÎÒÃǵı¨±íÖ±½ÓÓÃExcel´ò¿ª¡£»òÕßÊÇ£ºÎÒÃÇÒѾ­Ï°¹ßÓÃExcel´òÓ¡¡£ÕâÑù×ÓÈç¹ûÓÃ.net¿ª·¢ÊÇûÓÐÎÊÌâµÄ£¬µ«ÊÇÓÐj2eeÕâ¸ö±È.net¸üÓÐǰ;µÄ¿ª·ÅʽµÄ¿ª·¢»·¾³£¬ÄѵÀÎÒΪÁ˽â¾ö´òÓ¡µÄÒªÇóÈ¥Áíд¿Í»§¶ËµÄ¿Ø¼þ£¿»òÕßÔÚ·þÎñÆ÷¶ËʹÓñ¾µØ´úÂ룿µÚÒ»ÖÖ·½°¸µÄÎÊÌâÊǹؼüÊý¾ÝµÄ´¦ÀíÓÐʱºò²»ÄÜÔÚ¿Í»§¶Ë×ö£¬µÚ2ÖÖ·½°¸µÄÎÊÌâÊÇÎþÉüÁË´úÂëµÄ¿ÉÒÆÖ²ÐÔºÍÎȶ¨ÐÔ¡£
ApacheµÄJakataÏîÄ¿µÄPOI×ÓÏîÄ¿£¬Ä¿±êÊÇ´¦Àíole2¶ÔÏó¡£Ä¿Ç°±È½Ï³ÉÊìµÄÊÇHSSF½Ó¿Ú£¬´¦ÀíMS Excel£¨97-2002£©¶ÔÏó¡£ËûÊÇÕæÕýµÄExcel¶ÔÏ󣬿ÉÒÔ¿ØÖÆÒ»Ð©ÊôÐÔÈçsheet,cellµÈµÈ¡£ÏÖÔÚHSSFÒѾ­³ÉÊìµ½Äܹ»ºÍ×ã¹»ÎÒÃÇʹÓÃÁË
POI¿ÉÒÔµ½www.apache.orgÏÂÔØµ½¡£±àÒëºÃµÄjarÖ÷ÒªÓÐÕâÑù4¸ö£ºpoi°ü,poi Browser°ü,poi hdf°ü,poi hssfÀý³Ì°ü¡£Êµ¼ÊÔËÐÐʱ£¬ÐèÒªÓÐpoi°ü¾Í¿ÉÒÔÁË¡£
hssfµÄ¸÷ÖÖ¶ÔÏó¶¼ÓÐÀý³ÌµÄ½éÉÜ¡£hssfÌṩµÄÀý³ÌÔÚorg.apache.poi.hssf.usermodel.examples°üÖУ¬¹²ÓÐ14¸ö£¬Éú³ÉµÄÄ¿±êxls¶¼ÊÇworkbook.xls¡£
Èç¹ûÄãÏë¿´¸ü¶àµÄÀý³Ì£¬¿ÉÒԲο¼hssfµÄJunit test cases£¬ÔÚpoiµÄ°üµÄÔ´´úÂëÖÐÓС£hssf¶¼ÓвâÊÔ´úÂë¡£
ÄÇôJavaÊÇÔõôÑùʹÓÃPOI°ü²Ù×÷excelµÄ£¿
1¡£Ê×ÏÈÏÂÔØµ½http://www.apache.org/ÏÂÔØpoi£¬ÔÚ¹¤³ÌÖÐÒýÈëÈ»ºó£º
ÔÚservletÀïÃæµÄdoGet·½·¨Ð´·¨ÈçÏ£º
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import java.io.*;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//ÉèÖ÷µ»ØÊý¾ÝÀàÐÍ
response.setContentType("application/vnd.ms-excel;charset=GBK");
//ÉèÖ÷µ»ØµÄÎļþÃû
response.setHeader("Content-Disposition",
"attachment;Filename=Excel.xls");
//µÃµ½Êä³öÁ÷
OutputStream outStream = response.getOutputStream();
//н¨Ò»¸ö¹¤×÷±¡
HSSFWorkbook wb = new HSSFWorkbook();
//½¨Ò»¸ö²åÒ³
HSSFSheet sheet = wb.createSheet("new sheet");
//²åÈë¶àÐУ¬²¢¼ÓÈëÊý¾Ý
for(int i=0;i<10;i++){
HSSFRow rowi = sheet.createRo


Ïà¹ØÎĵµ£º

HibernateÖ®¸¸£º¸ÃÉý¼¶µ½Java EE 6ÁË

Hibernate Ö®¸¸ Gavin King[1]½¨Ò鿪·¢ÕßÉý¼¶µ½ Java EE 6 ƽ̨£¬²¢Ö¸³ö£¬Ä¿Ç°¸÷ÖÖ²»Ô¸ÒâÉý¼¶µÄ¹ÛµãÆäʵÊÇûÓиù¾ÝµÄ¡£
Java EE 6 ·¢²¼ºó£¬ÎÒ¿´µ½Á˺ܶ෴¶ÔÉý¼¶µ½ÐÂÆ½Ì¨µÄ¹Ûµã¡£ÕâЩ·´¶Ô¹Ûµã´ó¶àÊÇÓÉ Tomcat / Jetty ÒÔ¼°Ò»Ð©¿ªÔ´¿ò¼Ü£¨ÀýÈç Hibernate Óë Spring£©µÄʹÓÃÕßÌá³ö¡£
µ±È»£¬Ñ¡Ôñ·Ç±ê×¼¡¢¿ªÔ´¼¼ÊõÓкܶàºÃ´¦¡ ......

²»´íµÄ¾­µäÎÄÕ£ºjavaÌáËÙ

JavaÓïÑÔÌØ±ðÇ¿µ÷׼ȷÐÔ£¬µ«¿É¿¿µÄÐÐΪҪÒÔÐÔÄÜ×÷Ϊ´ú¼Û¡£ÕâÒ»ÌØµã·´Ó³ÔÚ×Ô¶¯ÊÕ¼¯À¬»ø¡¢ÑϸñµÄÔËÐÐÆÚ¼ì²é¡¢ÍêÕûµÄ×Ö½ÚÂë¼ì²éÒÔ¼°±£ÊصÄÔËÐÐÆÚͬ²½µÈµÈ·½Ãæ¡£¶ÔÒ»¸ö½âÊÍÐ͵ÄÐéÄâ»úÀ´Ëµ£¬ÓÉÓÚĿǰÓдóÁ¿Æ½Ì¨¿É¹©ÌôÑ¡£¬ËùÒÔ½øÒ»²½×è°­ÁËÐÔÄܵķ¢»Ó¡£
“ÏÈ×öÍêËü£¬ÔÙÖð²½ÍêÉÆ¡£ÐÒºÃÐèÒª¸Ä½øµÄµØ·½Í¨³£²»»áÌ«¶à¡£”£¨ ......

javaÖÐÈçºÎʵÏÖÎļþ´ò°üÉÏ´«ÒÔ¼°×Ô¶¯½âѹ


ÎÒÃÇÔÚ¿ª·¢ÏîÄ¿µÄʱºò,ÌØ±ðÊÇB/Sϵͳ,¾­³£»áÓöµ½ÒªÅúÁ¿ÉÏ´«ÎļþµÄÐèÇó,¶Ô´ËÐèÇóÒ»°ãÓÐÈçϼ¸¸ö½â¾ö·½°¸(ÒÔB/SΪÀý):
1. ÔÚ¿Í»§¶ËÌṩÎļþÉÏ´«½Ó¿Ú,Ò»´ÎÉÏ´«Ò»¸öÎļþ
2. Ò»´ÎÉÏ´«¶à¸öÎļþ
3. ½«ÐèÒªÉÏ´«µÄÎļþ´ò°ü,Ò»´ÎÉÏ´«µ½·þÎñÆ÷,²¢×Ô¶¯½âѹµ½Ö¸¶¨Ä¿Â¼
1,2·½·¨¶¼Óм¸¸öºÜÃ÷ÏԵIJ»×ã,Óû§¹¤×÷Á¿´ó,ÎļþÈç¹û¹ý´ó,ÔÚÍø ......

JavaÄÚ²¿ÀàµÄ×÷ÓÃ

Ò»¡¢ ¶¨Òå
·ÅÔÚÒ»¸öÀàµÄÄÚ²¿µÄÀàÎÒÃǾͽÐÄÚ²¿Àà¡£
¶þ¡¢ ×÷ÓÃ
1.ÄÚ²¿Àà¿ÉÒԺܺõÄʵÏÖÒþ²Ø,Ò²¾ÍÊÇ·â×°ÐÔ¡£Ò»°ãµÄ·ÇÄÚ²¿À࣬ÊDz»ÔÊÐíÓÐ private ÓëprotectedȨÏ޵쬵«ÄÚ²¿Àà¿ÉÒÔ
2.ÄÚ²¿ÀàÓµÓÐÍâΧÀàµÄËùÓÐÔªËØµÄ·ÃÎÊȨÏÞ
3.¿ÉÊÇʵÏÖ¶àÖØ¼Ì³Ð
4.¿ÉÒÔ±ÜÃâÐ޸ĽӿڶøÊµÏÖͬһ¸öÀàÖÐÁ½ÖÖͬÃû·½·¨µÄµ÷ÓÃ
 
Èý¡¢  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ