Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

java´¦Àí Excel(POI°ü)


×î½üÔÚÔÛÃÇÕâ¸öÂÛ̳Àï×ÜÄÜ¿´¼û´ó¼ÒÌá³öÓÃjava´¦ÀíExcelµÄÎÊÌ⣬ÓÐʱ»¹Éæ¼°µ½Í¼ÐεÄÎÊÌ⣬
´ó¼Ò¿´ÁËÕâƪÎÄÕºó£¬ÎÒÏëÒ»¶¨»á½â¾ö²»ÉÙÈ˵ÄÎÊÌ⣡
¿´µ½ÍøÉϺܶàÎÄÕ¶¼Ò»Ö±¶¼ÊÇ˵POIµÄAPI²»ÄÜ´¦ÀíͼÐΣ¬Ò²¾ÍÊDz»ÄÜÍùExcelÀïÃæ¼ÓÈëͼÐΡ£
µ«ÊÂʵÉÏ£¬POI3.0³öÀ´Ö®ºó£¬Õâ¸öÎÊÌâÒѾ­½â¾ö£¡ËùÒÔ˵£¬ÍùExcelÀïÃæ¼ÓÈëͼÐβ»±ØÒ»¶¨ÇóÖúÓÚJAVA EXCEL APIÁË¡£
×î½üÔÚһλ´ïÈ˵ÄÆô·¢Ï£¬ÖÕÓÚ½â¾öÁËÕâ¸öÎÊÌ⣬¾Í´Ë£¬Ð´ÏÂÕâЩ£¬Èç¹ûÓÐÈË¿´µ½µÄ»°£¬Ò²Ï£ÍûÄܶÔËûÓеã°ïÖú°É¡£
´úÂ룺
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
BufferedImage bufferImg = ImageIO.read(new File("D:\\fruit.PNG"));
ImageIO.write(bufferImg,"PNG",byteArrayOut);
HSSFClientAnchor anchor =
     new HSSFClientAnchor(5,0,500,122,(short) 0, 5,(short)10,15);    
HSSFPatriarch patri = sheet.createDrawingPatriarch();
patri.createPicture(anchor ,
       wb.addPicture(byteArrayOut.toByteArray(),
       HSSFWorkbook.PICTURE_TYPE_PNG));
                
ByteArrayOutputStream  outStream = new ByteArrayOutputStream();
wb.write(outStream);
ÉÏÃæ´úÂëÖ»ÊÇ´ó¸Å£¬µ«ÐèÒªÓõ½µÄÀ඼ÒѾ­Áгö¡£½ÓÏÂÀ´ÐèÒª×öµÄ¾ÍÊÇ°Ñ outStreamÊä³öµ½excelÎļþÖÐÈ¥ÁË¡£
¾ßÌåµÄÀàµÄdocument¿ÉÒÔÈ¥ÏÂÃæÍøÕ¾Éϲ鿴:
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html


Ïà¹ØÎĵµ£º

JAVAÁ¬½ÓÊý¾Ý¿â Oracle

±¾ÎÄÊ×ÏȽéÉÜjavaÁ¬½ÓoracleҪעÒâµÄ¼¸µã£¬È»ºó½éÉܼ¸ÖÖ³£ÓõÄÁ¬½Ó·½Ê½¡£
Ò»¡¢¼¸µã×¢Ò⣺
1¡¢ÔÚ¿Í»§¶ËÈí¼þ¿ª·¢ÖÐʹÓÃThinÇý¶¯³ÌÐò
     ÔÚ¿ª·¢JavaÈí¼þ·½Ã棬OracleµÄÊý¾Ý¿âÌṩÁËËÄÖÖÀàÐ͵ÄÇý¶¯³ÌÐò£¬¶þÖÖÓÃÓÚÓ¦ÓÃÈí¼þ¡¢applets¡¢servletsµÈ¿Í»§¶ËÈí¼þ£¬ÁíÍâ¶þÖÖÓÃÓÚÊý¾Ý¿âÖеÄJava´æ´¢¹ý³ÌµÈ·þÎñÆ ......

»ñÈ¡javaµÄ·¾¶

¶ÔÓÚJava³ÌÐò£¬ÎÞÂÛÊÇδ´ò°üµÄ»¹ÊÇ´ò°üµÄJAR»òWARÎļþ£¬ÓÐʱºò¶¼ÐèÒª»ñÈ¡ËüÔËÐÐËùÔÚĿ¼ÐÅÏ¢£¬ÈçºÎ×öµ½ÕâÒ»µãÄØ£¿
ÔÚJava´¦ÀíµÄÎļþϵͳÖУ¬Ä¿Â¼µÄ±íʾ·½Ê½ÓÐÁ½ÖÖ£º
£¨1£©¾ø¶ÔĿ¼£¬ËüÒÔ"/"ΪÆðʼ×Ö·û£¬´ú±í´Ó¸ùĿ¼Ï¿ªÊ¼Ñ°ÕÒ¸ø³öµÄĿ¼£¬Èç/c:/java
£¨2£©Ïà¶Ô·¾¶£¬ËüÒÔ²»´ø“/”µÄĿ¼Ãû±íʾ£¬±íʾÒÔµ±Ç ......

JAVAÍøÂçÓ¦ÓÃϵͳ¿ª·¢µÄÐÂ˼¿¼·½·¨

ÄãÒ²ÐíÊÇÒ»¸ö¹¤³Ìʦ£¬ÕýÔÚʹÓÃEJB¡¢Struts¡¢Hibernate¡¢SpringµÈ¸÷ÖÖ¹úÍâÁ÷ÐеĿò¼Ü¿ª·¢ÄãµÄϵͳÖеĸ÷¸ö²¿·Ö£¬ËüÃÇÖ®¼ä¿¿²»Í¬µÄÅäÖÃÎļþ¡¢½Ó¿Ú¡¢·þÎñÁ¬½ÓÔÚÒ»Æð£¬ÎªÕâЩ½Ó¿Ú¡¢ÅäÖᢷþÎñµÄ±àд¡¢µ÷Óã¬Í·ÌÛÂð£¿
ÄãÒ²ÐíÊÇÒ»¸öPM£¬ ÕýÔÚΪÄãµÄÏîÄ¿²ÉÓÃʲô¿ò¼Ü¡¢ÈçºÎ·Ö×é¡¢ÈçºÎЭµ÷¡¢¸÷ÖÖ¿ò¼ÜµÄÓÅÁÓ×öÆÀ¹À¡¢²âÊÔ£¬ÎªÄãµÄÓ¦Ó ......

JavaÔ¶³ÌͨѶ¿ÉÑ¡¼¼Êõ¼°Ô­Àí

ÔÚ·Ö²¼Ê½·þÎñ¿ò¼ÜÖУ¬Ò»¸ö×î»ù´¡µÄÎÊÌâ¾ÍÊÇÔ¶³Ì·þÎñÊÇÔõôͨѶµÄ£¬ÔÚJavaÁìÓòÖÐÓкܶà¿ÉʵÏÖÔ¶³ÌͨѶµÄ¼¼Êõ£¬ÀýÈ磺RMI¡¢MINA¡¢ESB¡¢Burlap¡¢Hessian¡¢SOAP¡¢EJBºÍJMSµÈ£¬ÕâЩÃû´ÊÖ®¼äµ½µ×ÊÇЩʲô¹ØϵÄØ£¬ËüÃDZ³ºóµ½µ×ÊÇ»ùÓÚʲôԭÀíʵÏÖµÄÄØ£¬Á˽âÕâЩÊÇʵÏÖ·Ö²¼Ê½·þÎñ¿ò¼ÜµÄ»ù´¡ÖªÊ¶£¬¶øÈç¹ûÔÚÐÔÄÜÉÏÓиߵÄÒªÇóµÄ»°£¬ÄÇÉ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ