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

Java Éú³É EXCEL POIÎĵµËµÃ÷

Java Éú³É EXCEL POIÎĵµËµÃ÷
POI°æ±¾:3.0.2-FINAL
ÏÂÔصØÖ·: http://poi.apache.org/index.html
 
Ò»°ãÔÚÏîÄ¿ÖÐÕæÕýҪʵÏÖÕâÑùÒ»¸ö±í¸ñµÄʱºò£¬ÀýÈçÏîÄ¿ÐèÒªÖÆ×÷±¨±íµÈµÈ£¬Í¨³£µÄ×ö·¨¶¼ÊÇÊÂÏȰѸñʽһÇеĶ«Î÷¶¼ÊÖ¶¯ÖÆ×÷ºÃ£¨Õâ¸ö×öºÃÁ˵ÄÎļþÔÚʵ¼ÊµÄÏîÄ¿ÀïÎÒÃdzÆ֮Ϊ“Êý¾ÝÄ£°å”£¬¼ò³Æ“Ä£°å”£©£¬È»ºóÔÚJavaÓ¦ÓÃÖÐÊʵ±µÄʱ»ú°ÑÕâ¸öÎļþ¶Á½øÀ´Ð޸ģ¬×îºóÔÙÁí´æµ½Ö¸¶¨µÄλÖûòÕß´«µÝ¸øÏÂÒ»¸ö´¦ÀíÕߣ¨ÀýÈçÒÔÁ÷µÄ·½Ê½Ë͸øServletµÈµÈ£©£¬ÕâÑùÆäʵPOI¾ßÌå×öµÄÊÂÇé¾ÍÊÇÏòÄ£°åÀïдҵÎñµÄÊý¾Ý£¬»¹ÊǺܷ½±ã¿ì½ÝµÄ¡£
Ò»POI ¶ÁÈ¡Excel »ù±¾¹¤×÷
   1. // Ö¸¶¨Òª¶ÁÈ¡µÄÎļþ£¬±¾ÀýʹÓÃÉÏÃæÉú³ÉµÄhelloworld.xls
              FileInputStream readFile = new FileInputStream("c:/ceshi.xls");
       // ´´½¨Ò»¸öWorkBook£¬´ÓÖ¸¶¨µÄÎļþÁ÷Öд´½¨£¬¼´ÉÏÃæÖ¸¶¨Á˵ÄÎļþÁ÷
         HSSFWorkbook wb = new HSSFWorkbook(readFile);
       // »ñÈ¡Ãû³ÆΪ“²âÊÔÒ³”µÄsheet
       // ×¢Ò⣬Èç¹û²»ÄÜÈ·¶¨¾ßÌåµÄÃû³Æ£¬¿ÉÒÔÓÃgetSheetAt(int)·½·¨È¡µÃSheet
       //HSSFSheet st = wb.getSheet("²âÊÔÒ³");
              HSSFSheet st = wb.getSheetAt(0);
     //´´½¨Ñùʽ±í£¬Ñùʽ±í¿ÉÒÔÉèÖõ¥Ôª¸ñµÄһЩÊôÐÔ ±ÈÈç±³¾°É«,Ëø¶¨×´Ì¬,ÐÐÁпí¸ßµÈ
     HSSFCellStyle normalStyle = wb.createCellStyle();
     //ÒÔÏÂÁз½Ê½´æ´¢µ±Ç°µ¥Ôª¸ñÑùʽ
µ¥Ôª¸ñ¶ÔÏó.setCellStyle(normalStyle);
 
¶þÉèÖÃÄ£°åÓ뽨Á¢ÐкÍÁÐ
1. Èç¹ûÔ¤ÏȵÄÄ£°åÓÐÄÚÈݵĻ°,ÔÚ²Ù×÷µÄʱºòÔòÖ»ÐèÒª¶ÁÈ¥µ±Ç°µ¥Ôª¸ñµÄÄÚÈÝÒÔ¼°Ñùʽ£¬»òÕß¿ÉÒÔÖØж¨Òå¡£(Èç¹ûûÓÐÄÚÈÝ,ÓÖÏëÒÔ¶ÁÈ¥µÄ·½Ê½À´»ñÈ¡ExcelµÄ»°£¬ÐèÒªÊÖ¶¯³õʼ»¯Ä£°å£¬Èç¸øÄ£°åÖÐÐèÒªÓõ½µÄµ¥Ôª¸ñÉèÖñ߿ò»òÕß±³¾°É«µÈ)
ÀýÈç
HSSFRow row = st.getRow(0);       //¶ÁÈ¡µÚÒ»ÐÐ
HSSFCell cell = row.getCell((short)0); //¶ÁÈ¡µÚÒ»ÐеÚÒ»¸ö×Ö¶Î
2. Èç¹ûÄ£°åÖÐÎ


Ïà¹ØÎĵµ£º

JavaỊ̈߳ºÏ̵߳ĵ÷¶È ºÏ²¢

JavaỊ̈߳ºÏ̵߳ĵ÷¶È-ºÏ²¢
 
Ï̵߳ĺϲ¢µÄº¬Òå¾ÍÊǽ«¼¸¸ö²¢ÐÐÏ̵߳ÄÏ̺߳ϲ¢ÎªÒ»¸öµ¥Ïß³ÌÖ´ÐУ¬Ó¦Óó¡¾°Êǵ±Ò»¸öÏ̱߳ØÐëµÈ´ýÁíÒ»¸öÏß³ÌÖ´ÐÐÍê±Ï²ÅÄÜÖ´ÐÐʱ¿ÉÒÔʹÓÃjoin·½·¨¡£
 
joinΪ·Ç¾²Ì¬·½·¨£¬¶¨ÒåÈçÏ£º
void join()    
    µÈ´ý¸ÃÏß³ÌÖÕÖ¹¡£   ......

Eclipse Java×¢ÊÍÄ£°åÉèÖÃÏê½â


ÉèÖÃ×¢ÊÍÄ£°åµÄÈë¿Ú£º Window->Preference->Java->Code Style->Code Template È»ºóÕ¹¿ªComments½Úµã¾ÍÊÇËùÓÐÐèÉèÖÃ×¢Ê͵ÄÔªËØÀ²¡£ÏÖ¾Íÿһ¸öÔªËØÖðÒ»½éÉÜ£º
Îļþ(Files)×¢ÊͱêÇ©£º
/**   
* @Title: ${file_name}
* @Package ${package_name}
* @Description: ${todo}(ÓÃÒ»¾ä»°ÃèÊö¸ÃÎļ ......

JavaỊ̈߳ºÐÂÌØÕ÷ Óзµ»ØÖµµÄÏß³Ì

JavaỊ̈߳ºÐÂÌØÕ÷-Óзµ»ØÖµµÄÏß³Ì
 
ÔÚJava5֮ǰ£¬Ïß³ÌÊÇûÓзµ»ØÖµµÄ£¬³£³£ÎªÁË“ÓД·µ»ØÖµ£¬ÆÆ·ÑÖÜÕÛ£¬¶øÇÒ´úÂëºÜ²»ºÃд¡£»òÕ߸ɴàÈƹýÕâµÀ¿²£¬×ß±ðµÄ·ÁË¡£
 
ÏÖÔÚJavaÖÕÓÚÓпɷµ»ØÖµµÄÈÎÎñ£¨Ò²¿ÉÒÔ½Ð×öỊ̈߳©ÁË¡£
 
¿É·µ»ØÖµµÄÈÎÎñ±ØÐëʵÏÖCallable½Ó¿Ú£¬ÀàËƵģ¬ÎÞ·µ»ØÖµµÄÈÎÎñ±ØÐëRu ......

JavaỊ̈߳ºÐÂÌØÕ÷ Ëø£¨ÉÏ£©

JavaỊ̈߳ºÐÂÌØÕ÷-Ëø£¨ÉÏ£©
 
ÔÚJava5ÖУ¬×¨ÃÅÌṩÁËËø¶ÔÏó£¬ÀûÓÃËø¿ÉÒÔ·½±ãµÄʵÏÖ×ÊÔ´µÄ·âËø£¬ÓÃÀ´¿ØÖƶԾºÕù×ÊÔ´²¢·¢·ÃÎʵĿØÖÆ£¬ÕâЩÄÚÈÝÖ÷Òª¼¯ÖÐÔÚjava.util.concurrent.locks °üÏÂÃ棬ÀïÃæÓÐÈý¸öÖØÒªµÄ½Ó¿ÚCondition¡¢Lock¡¢ReadWriteLock¡£
 
Condition
Condition ½« Object ¼àÊÓÆ÷·½·¨£¨wait¡¢notify ......

JavaỊ̈߳ºÐÂÌØÕ÷ ÐźÅÁ¿

JavaỊ̈߳ºÐÂÌØÕ÷-ÐźÅÁ¿
 
JavaµÄÐźÅÁ¿Êµ¼ÊÉÏÊÇÒ»¸ö¹¦ÄÜÍê±ÏµÄ¼ÆÊýÆ÷£¬¶Ô¿ØÖÆÒ»¶¨×ÊÔ´µÄÏû·ÑÓë»ØÊÕÓÐןÜÖØÒªµÄÒâÒ壬ÐźÅÁ¿³£³£ÓÃÓÚ¶àÏ̵߳ĴúÂëÖУ¬²¢Äܼà¿ØÓжàÉÙÊýÄ¿µÄÏ̵߳ȴý»ñÈ¡×ÊÔ´£¬²¢ÇÒͨ¹ýÐźÅÁ¿¿ÉÒÔµÃÖª¿ÉÓÃ×ÊÔ´µÄÊýÄ¿µÈµÈ£¬ÕâÀï×ÜÊÇÔÚÇ¿µ÷“ÊýÄ¿”¶þ×Ö£¬µ«²»ÄÜÖ¸³öÀ´ÓÐÄÄЩÔڵȴý£¬ÄÄЩ×ÊÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ