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Ị̈߳ºÏ̵߳Ľ»»¥
SCJP5ѧϰ±Ê¼Ç
Ï߳̽»»¥ÊDZȽϸ´ÔÓµÄÎÊÌ⣬SCJPÒªÇ󲻺ܻù´¡£º¸ø¶¨Ò»¸ö³¡¾°£¬±àд´úÂëÀ´Ç¡µ±Ê¹Óõȴý¡¢Í¨ÖªºÍ֪ͨËùÓÐÏ̡߳£
Ò»¡¢Ï߳̽»»¥µÄ»ù´¡ÖªÊ¶
SCJPËùÒªÇóµÄÏ߳̽»»¥ÖªÊ¶µãÐèÒª´Ójava.lang.ObjectµÄÀàµÄÈý¸ö·½·¨À´Ñ§Ï°£º
void notify()
......
JavaỊ̈߳ºÏ̵߳ĵ÷¶È-ÐÝÃß
JavaÏ̵߳÷¶ÈÊÇJava¶àÏ̵߳ĺËÐÄ£¬Ö»ÓÐÁ¼ºÃµÄµ÷¶È£¬²ÅÄܳä·Ö·¢»ÓϵͳµÄÐÔÄÜ£¬Ìá¸ß³ÌÐòµÄÖ´ÐÐЧÂÊ¡£
ÕâÀïÒªÃ÷È·µÄÒ»µã£¬²»¹Ü³ÌÐòÔ±Ôõô±àдµ÷¶È£¬Ö»ÄÜ×î´óÏ޶ȵÄÓ°ÏìÏß³ÌÖ´ÐеĴÎÐò£¬¶ø²»ÄÜ×öµ½¾«×¼¿ØÖÆ¡£
Ïß³ÌÐÝÃßµÄÄ¿µÄÊÇʹÏß³ÌÈóöCPUµÄ×î¼òµ¥µÄ×ö·¨Ö®Ò»£¬Ïß³ÌÐÝÃß ......
JavaỊ̈߳ºÐÂÌØÕ÷-ÐźÅÁ¿
JavaµÄÐźÅÁ¿Êµ¼ÊÉÏÊÇÒ»¸ö¹¦ÄÜÍê±ÏµÄ¼ÆÊýÆ÷£¬¶Ô¿ØÖÆÒ»¶¨×ÊÔ´µÄÏû·ÑÓë»ØÊÕÓÐןÜÖØÒªµÄÒâÒ壬ÐźÅÁ¿³£³£ÓÃÓÚ¶àÏ̵߳ĴúÂëÖУ¬²¢ÄÜ¼à¿ØÓжàÉÙÊýÄ¿µÄÏ̵߳ȴý»ñÈ¡×ÊÔ´£¬²¢ÇÒͨ¹ýÐźÅÁ¿¿ÉÒÔµÃÖª¿ÉÓÃ×ÊÔ´µÄÊýÄ¿µÈµÈ£¬ÕâÀï×ÜÊÇÔÚÇ¿µ÷“ÊýÄ¿”¶þ×Ö£¬µ«²»ÄÜÖ¸³öÀ´ÓÐÄÄЩÔڵȴý£¬ÄÄЩ×ÊÔ ......
JavaỊ̈߳ºÐÂÌØÕ÷-×èÈû¶ÓÁÐ
×èÈû¶ÓÁÐÊÇJava5Ïß³ÌÐÂÌØÕ÷ÖеÄÄÚÈÝ£¬Java¶¨ÒåÁË×èÈû¶ÓÁеĽӿÚjava.util.concurrent.BlockingQueue£¬×èÈû¶ÓÁеĸÅÄîÊÇ£¬Ò»¸öÖ¸¶¨³¤¶ÈµÄ¶ÓÁУ¬Èç¹û¶ÓÁÐÂúÁË£¬Ìí¼ÓÐÂÔªËØµÄ²Ù×÷»á±»×èÈûµÈ´ý£¬Ö±µ½ÓпÕλΪֹ¡£Í¬Ñù£¬µ±¶ÓÁÐΪ¿Õʱºò£¬ÇëÇó¶ÓÁÐÔªËØµÄ²Ù×÷ͬÑù»á×èÈûµÈ´ý£¬Ö±µ½ÓпÉÓÃÔªËØÎª ......
JavaỊ̈߳ºÐÂÌØÕ÷-×èÈûÕ»
¶ÔÓÚ×èÈûÕ»£¬Óë×èÈû¶ÓÁÐÏàËÆ¡£²»Í¬µãÔÚÓÚÕ»ÊÇ“ºóÈëÏȳö”µÄ½á¹¹£¬Ã¿´Î²Ù×÷µÄÊÇÕ»¶¥£¬¶ø¶ÓÁÐÊÇ“ÏȽøÏȳö”µÄ½á¹¹£¬Ã¿´Î²Ù×÷µÄÊǶÓÁÐÍ·¡£
ÕâÀïÒªÌØ±ð˵Ã÷Ò»µãµÄÊÇ£¬×èÈûÕ»ÊÇJava6µÄÐÂÌØÕ÷¡£¡¢
JavaΪ×èÈûÕ»¶¨ÒåÁ˽ӿڣºjava.util.concurrent.Block ......