javaÉú³ÉEXCEL±í¸ñ£¨POI vs JXL£©
javaÉú³Éexcel±í¸ñ£¬ÒÔǰֻ֪µÀPOI£¬ÕâÊÇApacheµÄ¿ªÔ´ÏîÄ¿£¬±¾À´ÊÇÒ»Ì׵쬰üÀ¨word£¬µ«ÊÇÒòΪwordµÄ¸´ÔÓÐÔ£¬ÒÔ¼°¿ª·¢ÈËÔ±µÄȱ·¦£¬ºÃÏñ»ù±¾Í£ÖÍÁË¡£Ö»ÓÐExcel×öµÄ»¹Ëã±È½ÏÍêÕû£¬ÓÃÆðÀ´±È½ÏÇáËÉ¡£
ºóÀ´ÒòΪ×öÏîÄ¿µÄ¹ØÏµ£¬ÖªµÀÁË»¹ÓиöJXL£¨java excel£©£¬Ò²ÊǸö¿ªÔ´ÏîÄ¿£¬ÓÃÆðÀ´µÄ¸Ð¾õ¸úPOIºÜÀàËÆ£¬ÒòΪÓõ½µÄ¹¦Äܶ¼ºÜ¼òµ¥£¬Ò²Ã»¾õµÃÓÐʲô´óµÄ²î¾à¡£ÍøÉÏÕÒÁËһЩËûÃǵÄÇø±ð£¬ËãÊǸø×Ô¼ºÉ¨Ã¤ÁË¡£
ÒÔÏÂΪתÌù£¬ºìɫΪ×Ô¼º±ê×¢¡£
×Ô´Ó MS ¹«¿ªÁË OFFICE µÄ±àÂë¸ñʽÒÔÀ´£¬ºÜ¶à¿ªÔ´µÄ×éÖ¯¶¼ÌṩÁË¶Ô Excel Ö§³Ö¶Áд²Ù×÷µÄ²å¼þ°ü¡£Java ÊÀ½çÀApacheÓ¦¸ÃËãÊÇ¿ªÔ´ÊÀ½çÖеÄÁìÍ·Ñò¡£ËûµÄJakarta Project ÖÐµÄ POI Project ¾ÍÌṩÁ˶ÔOFFICEµÄÍêÃÀÖ§³Ö£¨²»¹ý×î½üºÃÏñËû¶ÔWordµÄÖ§³ÖÏîÄ¿ÒѾֹͣ£¬¶øÇÒ¹«¿ªÔÚÍøÕ¾ÉÏȦÈËÄØ ^^ ,Èç¹ûÄã¶ÔWordÎļþµÄ±àÂë¸ñʽ·Ç³£ÊìϤ£¬¿ÉÒÔ·¢·âÓʼþŶ£¡£©£¬µ±È»³ý´ËÖ®Í⣬»¹ÓкܶàÆäËû¿ªÔ´×éÖ¯Ò²¶Ô Excel µÄ¶Áд²Ù×÷ÌṩÁ˺ܺõÄÖ§³Ö£¬ÆäÖмòµ¥¶øÇÒʵÓõıãÊÇ Display-tag £¬³ÌÐòÔ±¸ù±¾¾Í²»ÐèÒª¿¼ÂÇÈçºÎ½«Êý¾ÝºÏÀíµØÐ´ÈëExcelÖУ¬ÕâÒ»Çж¼ÊÇÓÉÆä Servlet ×Ô¶¯Íê³É£¬µ«Ò²ÕýÊÇÓÉÓÚËû¶Ô³ÌÐòÔ±ÊÇ͸Ã÷µÄ£¬Òò´ËΪºÜ¶à²Ù×÷Ò²´øÀ´Á˲»±ã¡£ÔÚ½ÓÏÂÀ´µÄÎÄ×ÖÖÐÎÒ»á½éÉÜÁíÍâÒ»ÖÖͬÑù¶ÔExcelÌṩÁËÍêÃÀÖ§³ÖµÄµÚÈý·½²å¼þ JXL £¬Java ExcelÊÇÒ»¿ª·ÅÔ´ÂëÏîÄ¿£¬Í¨¹ýËüJava¿ª·¢ÈËÔ±¿ÉÒÔ¶ÁÈ¡ExcelÎļþµÄÄÚÈÝ¡¢´´½¨ÐµÄExcelÎļþ¡¢¸üÐÂÒѾ´æÔÚµÄExcelÎļþ¡£Ê¹ÓøÃAPI·ÇWindows²Ù×÷ϵͳҲ¿ÉÒÔͨ¹ý´¿JavaÓ¦ÓÃÀ´´¦ÀíExcelÊý¾Ý±í¡£ÒòΪÊÇʹÓÃJava±àдµÄ£¬ËùÒÔÎÒÃÇÔÚWebÓ¦ÓÃÖпÉÒÔͨ¹ýJSP¡¢ServletÀ´µ÷ÓÃAPIʵÏÖ¶ÔExcelÊý¾Ý±íµÄ·ÃÎÊ¡£
Jakarta µÄ POI Project Óë Java Excel API ÔÚ¿ªÔ´ÊÀ½çÖпÉÒÔ˵ÊDz¢¼ÝÆëÇý£¬µ«ÊÇÒ²¸÷ÓÐÓÅÁÓ£¬poiÔÚijЩϸ½ÚÓÐЩСBug²¢ÇÒ²»Ö§³ÖдÈëͼƬ(poiÆäʵ¿ÉÒÔдÈëͼƬ£¬²»¹ýûÓÐjxlÀ´µÄ·½±ã£¬±È½ÏÂé·³)£¬ÆäËû·½Ã涼ͦ²»´íµÄ£»¶øJXLÌṩÁ˶ÔͼƬµÄÖ§³Ö£¨µ«Êǽö½öÖ§³Öpng¸ñʽµÄͼƬ£©£¬ÎÊÌâ¾ÍÊǶԹ«Ê½Ö§³Ö²»ÊǺܺ㬵«»¹ÊÇÌṩÁ˼òµ¥µÄ¹«Ê½¶Áȡ֧³Ö¡£Òò´ËÄãµÄÏîÄ¿ÖÐҪѡÓÃʲôÑùµÄµÚÈý·½²å¼þΪÍêÈ«ÓÉÄãµÄÓ¦ÓÃÀ´¾ö¶¨¡£Èç¹ûÄãµÄÈí¼þÊǸú²ÆÎñÓÐÏ൱µÄ¹ØÏµµÄ»°£¬½¨Òé²ÉÓà POI Project£¬¾ÍÎÒËùÔÚĿǰµÄÏîÄ¿À´ËµÓÉÓÚÓò»µ½¼ÆË㹫ʽ£¬¶øÇҺܿÉÄÜÐèÒªµ¼³öͼƬ£¬Òò´Ë£¬ÎÒµÄÑ¡ÔñÊÇ JXL ¡£
http://huanqingblog.blog.sohu.com/63922965.html
Ïà¹ØÎĵµ£º
¡¡¡¡×î½üÐèÒª×öһЩJAVAµ×²ã²Ù×÷£¬ÎªÁ˾¡¿ÉÄÜÌá¸ßЧÂÊ×öÁËÈçϲâÊÔ¡£
¡¡¡¡ÔÚͬһ¸öÀàÖн¨Á¢ÆÕͨµÄPUBLIC·½·¨ºÍPUBLIC STATIC ·½·¨Á½ÖÖ£¬²¢Ê¹ÓÃJUnit½øÐжà´ÎÑ»·¡£×îÖÕÖ¤Ã÷ʹÓöÔÏóµÄ·½Ê½µ÷ÓÃЧÂʸߡ£
¡¡¡¡ÉϽá¹û¡£
Æðʼʱ¼äFri Mar 05 10:15:37 CST 2010½áÊøÊ±¼äFri Mar 05 10:15:38 CST 2010ʱ¼ä¼ä¸ô891
Æðʼʱ¼äFri ......
JavaÉè¼ÆÄ£Ê½Ö®×ÛÊöƪ
http://tech.it168.com/a2009/0223/266/000000266380.shtml
×Ô´ÓJ2EE³öÏÖÒÔÀ´£¬¾Í´ó´ó¼ò»¯ÁËÔÚJavaÏÂµÄÆóÒµ¼¶¿ª·¢¡£µ«ÊÇËæ×ÅJ2EEÔ½À´Ô½ÆÕ±éµØ±»Ó¦Óõ½¸÷¸öÁìÓòÖУ¬¿ª·¢ÕßÃǽ¥½¥Òâʶµ½ÐèÒªÒ»ÖÖ·½·¨À´±ê×¼»¯Ó¦ÓóÌÐòµÄ¿ª·¢¹ý³Ì£¬ËûÃDzÉÓõķ½·¨ÊDZê×¼»¯Ó¦ÓóÌÐòµÄ½á¹¹²ã¡£Ôڽṹ²ãͨ³£·â×°ÁËһЩ¶ÀÁ¢Ó ......
תÁíÒ»¸öÂÛ̳µÄÌû×Ó£º
ѸÀ×ÃæÊÔ»ØÀ´£¬ÓÃÁËÕûÕûÒ»ÏÂÎ磨²»ÖªµÀÔõô˵ÁË£¬ÆäÖеȴýʱ¼ä¶¼¿ì2СʱÁË£©£¬×Ô¼º¸Ð¾õ±ÊÊÔºÍÉÏ»ú»¹¿ÉÒÔ£¬µ«¼¼ÊõÃæÌ¸ÕâÒ»¹Ø´ðµÃ²»Ì«ºÃ£¬ÏÖÔÚÔٴθоõ»¥ÁªÍø¹«Ë¾ÓëÒ»°ãÈí¼þ¹«Ë¾µÄÇø±ðÁË£¬ÆäÖÐÒ»µã¾ÍÊÇ»¥ÁªÍøÓ¦ÓÃÔÚÐÔÄÜÉÏÒªÇóºÜ¸ß£¬Ì¸ÁËÒ»¸öСʱ´ó²¿·ÖÌâÄ¿¸Ð¾õ¶¼ÔÚ̸ÂÛÐÔÄÜÎÊÌ⣬×Ô¼ºÔÚ·½ÃæÒ»Ö±ÊÇÈõÏî ......
Ä³Ð©ÍøÕ¾ÔÊÐíÈí¼þ¿ª·¢ÉçÍÅͨ¹ý·¢²¼¿ª·¢ÕßÖ¸ÄÏ¡¢°×ƤÊé¡¢FAQs¡¾³£¼ûÎÊÌâ½â´ð¡¿ºÍÔ´´úÂëÒÔʵÏÖÐÅÏ¢µÄ¹²Ïí¡£Ëæ×ÅÐÅÏ¢Á¿µÄÔö³¤£¬ºÍ¼¸¸ö¿ª·¢Õß¹±Ï׳ö×Ô¼ºµÄ֪ʶ¿â£¬ÓÚÊÇÍøÕ¾ÌṩËÑË÷ÒýÇæÀ´ËÑË÷Õ¾µãÉÏÏÖÓеÄËùÓÐÐÅÏ¢¡£ËäÈ»ÕâЩËÑË÷ÒýÇæ¶ÔÎı¾ÎļþµÄËÑË÷¿ÉÒÔ×öµÄºÜºÃ£¬µ«¶Ô¿ª·¢ÕßËÑË÷Ô´´úÂë×öÁ˱ȽÏÑϸñµÄÏÞÖÆ¡£ËÑË÷ÒýÇæÈÏΪԴ´úÂë ......
µÚÒ»ÕÂ ÒýÑÔ
(By wind5shy£ºhttp://blog.csdn.net/wind5shy)
µÚ¶þÕ ´´½¨ºÍÏú»Ù¶ÔÏó
(By wind5shy£ºhttp://blog.csdn.net/wind5shy)
µÚ1Ìõ£º¿¼ÂÇÓþ²Ì¬¹¤³§·½·¨´úÌæ¹¹Ô캯Êý
ºÃ´¦£º
¾²Ì¬¹¤³§·½·¨ÓÐÃû×Ö£¬±í´ï¸üÇå³þ¡£
²»Ðè´´½¨ÐµĶÔÏó¡£
¿ÉÒÔ·µ»ØÔ·µ»ØÀàÐ͵Ä×ÓÀàÐͶÔÏó¡£Ó¦Óãº1.·µ»ØÀàÐͶ¨ÒåΪ½ ......