Java Excel API——JXLÈëÃÅ
JXL(Java Excel API)ÊÇÒ»¸öÓÃÀ´¶¯Ì¬¶ÁдExcelÎļþµÄ¿ªÔ´¿ò¼Ü£¬ÀûÓÃËü¿ÉÒÔÔÚÈκÎÖ§³ÖJavaµÄ²Ù×÷ϵͳÉ϶¯Ì¬¶ÁдExcelÎļþ¡£JXLµÄÖ÷Ò³ÊÇ£ºhttp://www.andykhan.com/jexcelapi/£¬¿ÉÒÔÔÚÕâÀïÏÂÔØµ½ËüµÄ×îеİ汾¡£
Äã¿ÉÒÔ·Ö±ðͨ¹ýÈçÏÂÃüÁî
java -jar jxl.jar -xml test.xls
java -jar jxl.jar -cvs test.xls
ÒÔxmlºÍcvs¸ñʽ²é¿´test.xls£¬ÕâÊÇÒòΪJXL×÷ÕßʵÏÖÁËÒ»¸öÓÃÀ´ÑÝʾµÄjxl.demo.DemoµÄÀà¡£
µ±È»ÎÒÃÇʹÓÃJXLÖ÷ÒªÊÇÓÃËüÀ´¶¯Ì¬¶ÁдExcelÎļþ¡£ÏÖÔÚ¾ÍÀ´¿´¿´JXLÔÚ¶ÔExcelµÄ¶ÁºÍдÉ϶¼ÌṩÁËÄÇЩ֧³Ö¡£
ÏÈÀ´¿´¿´ExcelÎļþÖж¼ÓÐдÉÏÃæ¶ÔÏó
1 Îļþ¶ÔÏó 2¹¤×÷²¾¶ÔÏó 3 µ¥Ôª¸ñ¶ÔÏó¡£
ÏàÓ¦µÄÔÚJXLÖоÍÓÐWorkbook£¬Sheet £¬Cell ¡£Í¨¹ýÕâÈý¸ö¶ÔÏóÎÒÃǾͿÉÒÔʵÏÖExcelÎļþµÄ¶ÁÈ¡¹¤×÷¡£
ÎÒÃÇÏÈÏëÏëһ϶ÁÈ¡²½Ö裬²»¹ÜÊÇʲôÑùµÄExcel²Ù×÷¿ò¼Ü±Ø¶¨¶¼Òª¾Àú
1ѡȡExcelÎļþ£¬2Ñ¡Ôñ¹¤×÷²¾£¬3Ñ¡ÔñCell£¬4¶ÁÈ¡ÐÅÏ¢¡£
ÄÇôÏÖÔھͿÉÒÔ¿´¿´JXLÖÐÕâËIJ½ÖèÈçºÎÌåÏÖ£º
//ͨ¹ýWorkbookµÄ¾²Ì¬·½·¨getWorkbookѡȡExcelÎļþ
Workbook workbook = Workbook.getWorkbook(new File("myfile.xls"));
//ͨ¹ýWorkbookµÄgetSheet·½·¨Ñ¡ÔñµÚÒ»¸ö¹¤×÷²¾£¨´Ó0¿ªÊ¼£©
Sheet sheet = workbook.getSheet(0);
//ͨ¹ýSheet·½·¨µÄgetCell·½·¨Ñ¡ÔñλÖÃΪC2µÄµ¥Ôª¸ñ£¨Á½¸ö²ÎÊý¶¼´Ó0¿ªÊ¼£©
Cell c2 = sheet.getCell(2,1);
//ͨ¹ýCellµÄgetContents·½·¨°Ñµ¥Ôª¸ñÖеÄÐÅÏ¢ÒÔ×Ö·ûµÄÐÎʽ¶ÁÈ¡³öÀ´
String stringc2 = c2.getContents();
¿ÉÒÔ¿´µ½ÕýÊǸղÅËù˵µÄËĸö²½Öè¡£
ÎÒÃǶ¼ÖªµÀExcelµ¥Ôª¸ñÊÇÓиñʽµÄ£¬ÄÇôÕâЩÐÅÏ¢ÈçºÎÈ¡µÃ¡£
CellÌṩÁËÒ»¸ögetType·½·¨Äܹ»·µ»Øµ¥Ôª¸ñµÄÀàÐÍÐÅÏ¢£¬Í¬Ê±JXLÌṩÁËÒ»¸öCellTypeÀàÓÃÀ´Ô¤ÉèExcelÖеÄÀàÐÍÐÅÏ¢£¬¶øÇÒJXLÌṩÁËһЩCellÀàµÄ×ÓÀàÓÃÀ´·Ö±ðÓÃÀ´±íʾ¸÷ÖÖÀàÐ͵ĵ¥Ôª¸ñ£¬ÈçLabelCell£¬NumberCell£¬DateCell·Ö±ð±íʾ×Ö·û¡¢ÊýÖµ¡¢ÈÕÆÚÀàÐ͵ĵ¥Ôª¸ñ¡£ËùÒÔÎÒÃÇ¿ÉÒÔÕâÑùд£º
if (c2.getType() == CellType.NUMBER)
{
NumberCell nc = (NumberCell) c2;
numberb2 = nc.getValue();
}
×îºó²»ÒªÍü¼Ç¹Ø±ÕworkbookÒÔÊÍ·Å×ÊÔ´£º
workbook.close();
ÏÖÔÚ×ܽáÒ»ÏÂ:Èý¸ö¶ÔÏó£¬Ëĸö²½Ö裬עÒâ¸ñʽ¡£¾Í¿ÉÒÔÇáËɵĴÓExcelÎļþÖжÁÈ¡Êý¾Ý¡£
Ïà¹ØÎĵµ£º
½ñÌìÊÇÏîÄ¿µÄµÚÈýÌìÁË£¬ºÍ×òÌìµÄÄÚÈݲ¶à£¬ËùÒÔ½ñÌìµÄ×ܽáûÓÐÎ§ÈÆÏîĿչ¿ª£¬ÎÒÖ®ËùÒÔ£¬ÒªÄóöCVS/SVNÀ´ËµµÄÔÒòÊÇÒòΪ°æ±¾¿ØÖÆÆ÷·Ç³£µÄÖØÒª£¬ÒòΪÒÔºóÎÒÃǽøÈ빫˾֮ºó£¬µÚÒ»´ÎÊÂÇé¾ÍÊǸæËßµ¥ÈË¿ª·¢µÄģʽ £¬´ó¼Ò¶¼ÖªµÀÔÚÆóÒµÀïÃæ£¬ÊDz»ÊÇÊÇÒ»¸öÈË¿ª·¢µÄ£¬ÊÇÐ×÷¿ª·¢¡£ËùÒÔ£¬×÷Ϊһ¸öÓпª·¢¾ÑéµÄͬ־¶¼ÖªµÀ£¬ÕâÁ ......
java²»½öÊDZà³ÌÓïÑÔ£¬»¹ÊÇÒ»¸ö¿ª·¢Æ½Ì¨£¬java¼¼Êõ¸ø³ÌÐòÔ±ÌṩÁËÐí¶à¹¤¾ß£º±àÒëÆ÷¡¢½âÊÍÆ÷¡¢ÎĵµÉú³ÉÆ÷ºÍÎļþ´ò°ü¹¤¾ßµÈµÈ¡£Í¬Ê±java»¹ÊÇÒ»¸ö³ÌÐò·¢²¼Æ½Ì¨£¬ÓÐÁ½ÖÖÖ÷ÒªµÄ"·¢²¼»·¾³"£¬Ê×ÏÈjavaÔËÐÐʱ»·¾³£¨java runtime environment£¬¼ò³ÆJRE£©°üº¬ÁËÍêÕûµÄÀàÎļþ°ü£¬Æä´ÎÐí¶àÖ÷ÒªµÄä¯ÀÀÆ÷¶¼ÌṩÁËjava½âÊÍÆ÷ºÍÔËÐÐʱ»·¾³¡£Ä ......
Èí¼þ¿ª·¢Ö®Â·ÊdzäÂú¾£¼¬ÓëÌôս֮·,Ò²ÊdzäÂúÏ£Íû֮·¡£JavaѧϰҲÊÇÈç´Ë£¬Ã»Óнݾ¶¿É×ß¡£ÃÎÏëÏñ¡¶ÌìÁú°Ë²¿¡·ÖÐÐéÖñÒ»Ñù±»ÎÞÑÂ×Óõ®õ¹à¶¥¶øÇáËÉ»ñµÃÒ»¼××Ó¹¦Á¦£¬ÊǺܲ»ÏÖʵµÄ¡£Ã¿ÌìÑöÌì´ó½Ð"ÌìÉñ°¡£¬Çë´Í¸øÎÒÒ»±¾¿û»¨±¦µä°É"£¬Êâ²»Öª¼´Ê¹Äã»ñµÃÁË¿û»¨±¦µä£¬³ýÁËÊÜ×Ô¹¬ÆäÉíÖ®¿àÍ⣬ÄãÒ²²»Ò»¶¨³ÉµÃÁË"¶«·½²»°Ü"£¬µ¹ÊdzÉ"Î÷·½Ê§ ......
JavaÀïÓиöºÜÖØÒªµÄÌØÉ«ÊÇException £¬Ò²¾ÍÊÇ˵ÔÊÐí³ÌÐò²úÉúÀýÍâ×´¿ö¡£¶øÔÚѧJava µÄʱºò£¬ÎÒÃÇÒ²Ö»ÖªµÀException µÄд·¨£¬È´Î´±ØÕæÄÜÁ˽ⲻͬÖÖÀàµÄException µÄÇø±ð¡£
Ê×ÏÈ£¬ÄúÓ¦¸ÃÖªµÀµÄÊÇJava ÌṩÁËÁ½ÖÖException µÄģʽ£¬Ò»ÖÖÊÇÖ´ÐеÄʱºòËù²úÉúµÄException (Runtime Exception)£¬ÁíÍâÒ»ÖÖÔòÊÇÊÜ¿ØÖƵÄException ......