Java²Ù×÷Excel£ºbook±£»¤
ExcelµÄbook±£»¤ÊǺܳ£Óõģ¬Ö÷ÒªÊDz»ÏëÈñðÈËÐÞ¸ÄExcelµÄʱºòÓá£ÕâÑùÄܹ»±ÜÃâ¶ñÒâËæ±ãÐÞ¸ÄÊý¾Ý£¬Ìá¸ßÊý¾ÝµÄ¿ÉÐжȡ£
ÄÇôJAVAÀ´ÊµÏÖÉèÖÃbook±£»¤Ôõô×öÄØ£¿
²éÕÒÁ˼¸ÖÖ³£¼ûµÄJAVA²Ù×÷ExcelµÄһЩ°ü£¬´óÌå½á¹ûÈçÏ£º
1. POI
POIµÄHSSFWorkbookÀàÓÐwriteProtectWorkbook(password, username)¡£Õâ±ß¿ÉÒÔÉèÖÃÃÜÂëºÍÊÂ˱£»¤µÄ£¬µ«Õâ¸ö¹ËÃû˼Òå¾Íд±£»¤£¬ÊµÏÖºÍExcelµÄbook±£»¤ÓгöÈë¡£
µ±È»£¬sheet±£»¤µÄ»°ÓÃHSSFSheetÀàµÄprotectSheet(password)·½·¨¾Í¿ÉÒÔÁË¡£
2. JXL
WorkbookÀàµÄsetProtected£¨boolean£©·½·¨¸Ð¾õÊÇÓÃÀ´×öbook±£»¤µÄ£¬µ«¿´ÁË˵Ã÷ÊÇÉèÖÃsheet±£»¤µÄ¡£Òò´ËÒ²ÊÇʵÏÖ²»ÁËbook±£»¤µÄЧ¹û¡£
3. OpenXLS
×îºóºÃ²»ÈÝÒ×ÕÒµ½ÁËÕâ¸ö°ü¡£WorkBookµÄsetProtected(true)·½·¨ÉèÖúó¾ÍʵÏÖÁËbook±£»¤¡£´úÂëÈçÏ£º
// read file
WorkBook workbook = new WorkBookHandle(new FileInputStream(new File("d:/openxlsTest.xls")));
// protect
workbook.setProtected(true);
// write file
workbook.writeBytes(new FileOutputStream(new File("d:/openxlsProtect.xls")));
book±£»¤ºóµÄЧ¹û£¬sheet²»ÄÜÔö¼Ó£¬É¾³ýµÈ
Ïà¹ØÎĵµ£º
Java NIO APIÏê½â
ÔÚJDK
1.4ÒÔǰ£¬JavaµÄIO²Ù×÷¼¯ÖÐÔÚjava.ioÕâ¸ö°üÖУ¬ÊÇ»ùÓÚÁ÷µÄ×èÈû£¨blocking£©API¡£¶ÔÓÚ´ó¶àÊýÓ¦ÓÃÀ´Ëµ£¬ÕâÑùµÄAPIʹÓúܷ½
±ã£¬È»¶ø£¬Ò»Ð©¶ÔÐÔÄÜÒªÇó½Ï¸ßµÄÓ¦Óã¬ÓÈÆäÊÇ·þÎñ¶ËÓ¦Óã¬ÍùÍùÐèÒªÒ»¸ö¸üΪÓÐЧµÄ·½Ê½À´´¦ÀíIO¡£´ÓJDK 1.4Æð£¬NIO
API×÷Ϊһ¸ö»ùÓÚ»º³åÇø£¬²¢ÄÜÌṩ·Ç×èÈû(non-blo ......
Java™ ÓïÑÔ°üº¬Á½ÖÖÄÚÔÚµÄͬ²½»úÖÆ£ºÍ¬²½¿é£¨»ò·½·¨£©ºÍ volatile ±äÁ¿¡£ÕâÁ½ÖÖ»úÖÆµÄÌá³ö¶¼ÊÇΪÁËʵÏÖ´úÂëÏ̵߳ݲȫÐÔ¡£ÆäÖÐ Volatile ±äÁ¿µÄͬ²½ÐԽϲµ«ÓÐʱËü¸ü¼òµ¥²¢ÇÒ¿ªÏú¸üµÍ£©£¬¶øÇÒÆäʹÓÃÒ²¸üÈÝÒ׳ö´í¡£ÔÚÕâÆÚµÄ Java ÀíÂÛÓëʵ¼ù
ÖУ¬Brian Goetz ½«½éÉܼ¸ÖÖÕýȷʹÓà volatile ±äÁ¿µÄģʽ£¬²¢Õ ......
1¡¢ÃæÏò¶ÔÏóµÄÌØÕ÷ÓÐÄÄЩ·½Ãæ
1.³éÏó£º
³éÏó¾ÍÊǺöÂÔÒ»¸öÖ÷ÌâÖÐÓ뵱ǰĿ±êÎ޹صÄÄÇЩ·½Ã棬ÒÔ±ã¸ü³ä·ÖµØ×¢ÒâÓ뵱ǰĿ±êÓйصķ½Ãæ¡£³éÏó²¢²»´òËãÁ˽âÈ«²¿ÎÊÌ⣬¶øÖ»ÊÇÑ¡ÔñÆäÖеÄÒ»²¿·Ö£¬ÔÝʱ²»Óò¿·Öϸ½Ú¡£³éÏó°üÀ¨Á½¸ö·½Ã棬һÊǹý³Ì³éÏ󣬶þÊÇÊý¾Ý³éÏó¡£
2.¼Ì³Ð£º
¼Ì³ÐÊÇÒ»ÖÖÁª½áÀàµÄ²ã´ÎÄ£ÐÍ£¬²¢ÇÒÔÊÐíºÍ¹Ä ......
ÏÂÔØµØÖ·:
http://www.andykhan.com/jexcelapi/ µ±Ç°µÄ×î¸ß°æ±¾ÊÇ2.6¡£
ÕæÊµÏÂÔØµØÖ·:
http://www.andykhan.com/jexcelapi/download.html
×÷ÕßµÄÍøÕ¾É϶ÔËüµÄÌØÕ÷ÓÐÈçÏÂÃèÊö£º
¡ñ Ö§³ÖExcel 95-2000µÄËùÓа汾
¡ñ Éú³ÉExcel 2000±ê×¼¸ñʽ
¡ñ Ö§³Ö×ÖÌå¡¢Êý×Ö ......
×î½üÏîÄ¿ÖÐÓöµ½ÁËÉÏÒÆÏÂÒÆ²Ù×÷µÄÒ»¸ö²Ù×÷£¬ÒÔǰҲ¿´µ½¹ý£¬µ«Ò»Ö±Ã»ÓÐÈ¥Ñо¿¹ý£¬Õâ´ÎÏîÄ¿ÖÐÓöµ½ÁË£¬Ò²¾ÍÈ¥Ñо¿ÁËÒ»°Ñ£¬ÆäʵʵÏÖÔÀíҲͦ¼òµ¥µÄ£¬Ëµ°×Á˾ÍÊÇ
Òª¼Ç¼Êý¾Ý¿âÀïµÄÒª½øÐÐÅÅÐò±íµÄ×ܼǼÊýÁ¿£¬È»ºó¸ù¾ÝÑ»·µÄ´ÎÊý£¬¶àд¼¸¸öÒþ²Ø±äÁ¿£¬½øÐÐÉÏÒÆÏÂÒÆ²Ù×÷µÄʱºò½øÐÐÅжϾͿÉÒÔÁË¡£
&n ......