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ѧϰ´ÓÈëÃŵ½¾«Í¨
Ò»¡¢ JDK (Java Development Kit)
JDKÊÇÕû¸öJavaµÄºËÐÄ£¬°üÀ¨ÁËJavaÔËÐл·¾³£¨Java Runtime Envirnment£©£¬Ò»¶ÑJava¹¤¾ßºÍJava»ù´¡µÄÀà¿â(rt.jar)¡£²»ÂÛʲôJavaÓ¦Ó÷þÎñÆ÷ʵÖʶ¼ÊÇÄÚÖÃÁËij¸ö°æ±¾µÄJDK¡£Òò´ËÕÆÎÕJDKÊÇѧºÃJavaµÄµÚÒ»²½¡£×îÖ÷Á÷µÄJ ......
Java™ ÓïÑÔ°üº¬Á½ÖÖÄÚÔÚµÄͬ²½»úÖÆ£ºÍ¬²½¿é£¨»ò·½·¨£©ºÍ volatile ±äÁ¿¡£ÕâÁ½ÖÖ»úÖÆµÄÌá³ö¶¼ÊÇΪÁËʵÏÖ´úÂëÏ̵߳ݲȫÐÔ¡£ÆäÖÐ Volatile ±äÁ¿µÄͬ²½ÐԽϲµ«ÓÐʱËü¸ü¼òµ¥²¢ÇÒ¿ªÏú¸üµÍ£©£¬¶øÇÒÆäʹÓÃÒ²¸üÈÝÒ׳ö´í¡£ÔÚÕâÆÚµÄ Java ÀíÂÛÓëʵ¼ù
ÖУ¬Brian Goetz ½«½éÉܼ¸ÖÖÕýȷʹÓà volatile ±äÁ¿µÄģʽ£¬²¢Õ ......
Ê®Äêǰ£¬Sun΢ϵͳ¹«Ë¾½«Java°áµ½ÁËÊÀÈËÃæÇ°£¬ÕâÊÇÊ×´ÎÐÖúÆóÒµ½¨Á¢¾ßÓÐǰհÐÔµÄ˼ÏëµÄÒ»¿îÈí¼þ£¬ËæºóJavaѸÃÍÀ©É¢£¬ÉîÈëµ½¼ÆËã»úÒµµÄ¼¸ºõÿ¸ö½ÇÂä¡£ÕâÏî¼¼ÊõµÄÄ»ºóÓ¢ÐÛ£¬¾ÍÊDZ¾ÎIJɷõÄJames Gosling¡£
ÉϸöÊÀ¼Í90Äê´ú³õ£¬Gosling·¢Æð²¢Áìµ¼ÁËÒ»¸öÃûΪGreenµÄÏîÄ¿£¬´ËÏîÄ¿×îÖÕÑݱäΪJava¡£Java µÄ»ù±¾ÀíÄîÊÇ´´ÔìÒ»ÖÖ¿ÉÒÔ ......
ÔÚÒ»¸öÃæÏò¶ÔÏóµÄϵͳÖУ¬ÏµÍ³µÄ¸÷ÖÖ¹¦ÄÜÊÇÓÉÐíÐí¶à¶àµÄ²»Í¬¶ÔÏóÐ×÷Íê³ÉµÄ¡£ÔÚÕâÖÖÇé¿öÏ£¬¸÷¸ö¶ÔÏóÄÚ²¿ÊÇÈçºÎʵÏÖ×Ô¼ºµÄ¶ÔϵͳÉè¼ÆÈËÔ±À´½²¾Í²»ÄÇÃ´ÖØÒª
ÁË£»¶ø¸÷¸ö¶ÔÏóÖ®¼äµÄÐ×÷¹ØÏµÔò³ÉΪϵͳÉè¼ÆµÄ¹Ø¼ü¡£Ð¡µ½²»Í¬ÀàÖ®¼äµÄͨÐÅ£¬´óµ½¸÷Ä£¿éÖ®¼äµÄ½»»¥£¬ÔÚϵͳÉè¼ÆÖ®³õ¶¼ÊÇÒª×ÅÖØ¿¼Âǵģ¬ÕâÒ²ÊÇϵͳÉè¼ÆµÄÖ÷
Òª ......