Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ị̈߳ºÏß³Ì״̬µÄת»»
 
SCJP5ѧϰ±Ê¼Ç
 
Ò»¡¢Ïß³Ì״̬
 
Ï̵߳Ä״̬ת»»ÊÇÏ߳̿ØÖƵĻù´¡¡£Ïß³Ì״̬×ܵĿɷÖΪÎå´ó״̬£º·Ö±ðÊÇÉú¡¢ËÀ¡¢¿ÉÔËÐС¢ÔËÐС¢µÈ´ý/×èÈû¡£ÓÃÒ»¸öͼÀ´ÃèÊöÈçÏ£º
 
1¡¢ÐÂ״̬£ºÏ̶߳ÔÏóÒѾ­´´½¨£¬»¹Ã»ÓÐÔÚÆäÉϵ÷ÓÃstart()·½·¨¡£
 
2¡¢¿ÉÔËÐÐ״̬£ºµ±Ïß³ÌÓÐ× ......

JavaỊ̈߳ºÏ̵߳ĵ÷¶È ÐÝÃß

JavaỊ̈߳ºÏ̵߳ĵ÷¶È-ÐÝÃß
 
JavaÏ̵߳÷¶ÈÊÇJava¶àÏ̵߳ĺËÐÄ£¬Ö»ÓÐÁ¼ºÃµÄµ÷¶È£¬²ÅÄܳä·Ö·¢»ÓϵͳµÄÐÔÄÜ£¬Ìá¸ß³ÌÐòµÄÖ´ÐÐЧÂÊ¡£
 
ÕâÀïÒªÃ÷È·µÄÒ»µã£¬²»¹Ü³ÌÐòÔ±Ôõô±àдµ÷¶È£¬Ö»ÄÜ×î´óÏ޶ȵÄÓ°ÏìÏß³ÌÖ´ÐеĴÎÐò£¬¶ø²»ÄÜ×öµ½¾«×¼¿ØÖÆ¡£
 
Ïß³ÌÐÝÃßµÄÄ¿µÄÊÇʹÏß³ÌÈóöCPUµÄ×î¼òµ¥µÄ×ö·¨Ö®Ò»£¬Ïß³ÌÐÝÃß ......

JavaỊ̈߳ºÏ̵߳ĵ÷¶È ÓÅÏȼ¶

JavaỊ̈߳ºÏ̵߳ĵ÷¶È-ÓÅÏȼ¶
 
ÓëÏß³ÌÐÝÃßÀàËÆ£¬Ï̵߳ÄÓÅÏȼ¶ÈÔÈ»ÎÞ·¨±£ÕÏÏ̵߳ÄÖ´ÐдÎÐò¡£Ö»²»¹ý£¬ÓÅÏȼ¶¸ßµÄÏ̻߳ñÈ¡CPU×ÊÔ´µÄ¸ÅÂʽϴó£¬ÓÅÏȼ¶µÍµÄ²¢·Çû»ú»áÖ´ÐС£
 
Ï̵߳ÄÓÅÏȼ¶ÓÃ1-10Ö®¼äµÄÕûÊý±íʾ£¬ÊýÖµÔ½´óÓÅÏȼ¶Ô½¸ß£¬Ä¬ÈϵÄÓÅÏȼ¶Îª5¡£
 
ÔÚÒ»¸öÏß³ÌÖпªÆôÁíÍâÒ»¸öÐÂỊ̈߳¬ÔòпªÏ̳߳ÆÎ ......

JavaỊ̈߳ºÏ̵߳ĵ÷¶È ÊØ»¤Ïß³Ì

JavaỊ̈߳ºÏ̵߳ĵ÷¶È-ÊØ»¤Ïß³Ì
 
ÊØ»¤Ïß³ÌÓëÆÕͨÏß³Ìд·¨ÉÏ»ù±¾Ã´É¶Çø±ð£¬µ÷ÓÃÏ̶߳ÔÏóµÄ·½·¨setDaemon(true)£¬Ôò¿ÉÒÔ½«ÆäÉèÖÃÎªÊØ»¤Ï̡߳£
 
ÊØ»¤Ïß³ÌʹÓõÄÇé¿ö½ÏÉÙ£¬µ«²¢·ÇÎÞÓ㬾ÙÀýÀ´Ëµ£¬JVMµÄÀ¬»ø»ØÊÕ¡¢ÄÚ´æ¹ÜÀíµÈÏ̶߳¼ÊÇÊØ»¤Ï̡߳£»¹ÓоÍÊÇÔÚ×öÊý¾Ý¿âÓ¦ÓÃʱºò£¬Ê¹ÓõÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Á¬½Ó³Ø±¾ÉíÒ²°üº ......

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

JavaỊ̈߳ºÐÂÌØÕ÷-Ëø£¨Ï£©
 
ÔÚÉÏÎÄÖÐÌáµ½ÁËLock½Ó¿ÚÒÔ¼°¶ÔÏó£¬Ê¹ÓÃËü£¬ºÜÓÅÑŵĿØÖÆÁ˾ºÕù×ÊÔ´µÄ°²È«·ÃÎÊ£¬µ«ÊÇÕâÖÖËø²»Çø·Ö¶Áд£¬³ÆÕâÖÖËøÎªÆÕÍ¨Ëø¡£ÎªÁËÌá¸ßÐÔÄÜ£¬JavaÌṩÁ˶ÁÐ´Ëø£¬ÔÚ¶ÁµÄµØ·½Ê¹ÓöÁËø£¬ÔÚдµÄµØ·½Ê¹ÓÃÐ´Ëø£¬Áé»î¿ØÖÆ£¬ÔÚÒ»¶¨³Ì¶ÈÉÏÌá¸ßÁ˳ÌÐòµÄÖ´ÐÐЧÂÊ¡£
 
JavaÖжÁÐ´ËøÓиö½Ó¿Újava ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ