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
Ïà¹ØÎĵµ£º
StringתCharacterÊý×飬ÓÃCharacterµÄisDigitºÍisLetterº¯ÊýÈ¥Åжϡ£
public static boolean isNumeric(String str) {
for (int i = str.length(); i = 0;) {
if (!Character.isDigit(str.charAt(i))) {
return false;
}
}
return true;
}
public static boolean isNumeric(String str) {
Pattern patt ......
1¡¢ÖÐÎÄÎÊÌâµÄÀ´Ô´
ÓÉÓÚJava
Óï
ÑÔÄÚ²¿²ÉÓÃUNICODE±àÂ룬ËùÒÔÔÚJAVA
³ÌÐòÔËÐÐʱ£¬¾Í´æÔÚ×ÅÒ»¸ö´ÓUNICODE±àÂëºÍ¶ÔÓ¦µÄ²Ù×÷ϵͳ¼°ä¯ÀÀÆ÷Ö§³ÖµÄ±àÂë¸ñʽ
ת
»»ÊäÈë¡¢Êä³öµÄÎÊÌ⣬Õâ¸öת»»¹ý³ÌÓÐ×ÅһϵÁеIJ½Ö裬Èç¹ûÆäÖÐÈκÎÒ»²½³ö´í£¬ÔòÏÔʾ³öÀ´µÄºº×־ͻá³öÊÇÂÒÂ룬Õâ¾ÍÊÇÎÒÃdz£¼ûµÄJAVA
ÖÐ
ÎÄÎÊÌâ¡£¼¸ºõËùÓÐµÄ ......
ÎÒʹÓÃURLÀàÀ´·ÃÎÊFTP·þÎñÆ÷£¬µ±µØÖ·ÖÐûÓÐÖÐÎÄʱûÓÐÎÊÌ⣬µ«ÊÇ
µ±ftpÖеÄÎļþ¼ÐÓÐÖÐÎÄʱ£¬¾ÍÎÞ·¨·ÃÎÊÁË£¬ÎÒÊÔ¹ýencoderºÍdecoderÀ࣬¶¼²»ÐУ¬ÓÐʲô½â¾ö·½·¨Ã´£¿
URL now = new URL("ftp://202.204.208.124/Èí¼þ/");
......
ҪʹÓÃdom4j¶ÁдXMLÎĵµ,ÐèÒªÏÈÏÂÔØdom4j°ü,dom4j¹Ù·½ÍøÕ¾ÔÚ http://www.dom4j.org/
Ä¿Ç°×îÐÂdom4j°üÏÂÔصØÖ·: http://nchc.dl.sourceforge.net/sourceforge/dom4j/dom4j-1.6.1.zip
½â¿ªºóÓÐÁ½¸ö°ü,½ö²Ù×÷XMLÎĵµµÄ»°°Ñdom4j-1.6.1.jar¼ÓÈ빤³Ì¾Í¿ÉÒÔÁË,Èç¹ûÐèҪʹÓÃXPathµÄ»°»¹ÐèÒª¼ÓÈë°üjaxen-1.1-beta-7.jar.
ÒÔÏÂ ......
µÚÒ»ÕÂ ÒýÑÔ
(By wind5shy£ºhttp://blog.csdn.net/wind5shy)
µÚ¶þÕ ´´½¨ºÍÏú»Ù¶ÔÏó
(By wind5shy£ºhttp://blog.csdn.net/wind5shy)
µÚ1Ìõ£º¿¼ÂÇÓþ²Ì¬¹¤³§·½·¨´úÌæ¹¹Ô캯Êý
ºÃ´¦£º
¾²Ì¬¹¤³§·½·¨ÓÐÃû×Ö£¬±í´ï¸üÇå³þ¡£
²»Ðè´´½¨ÐµĶÔÏó¡£
¿ÉÒÔ·µ»ØÔ·µ»ØÀàÐ͵Ä×ÓÀàÐͶÔÏó¡£Ó¦Óãº1.·µ»ØÀàÐͶ¨ÒåΪ½ ......