JEECG Export Pictures to Excel

ImportJava.awt.image.BufferedImage;ImportJava.io.ByteArrayOutputStream;ImportJava.io.File;ImportJava.io.FileOutputStream;Importjava.io.IOException;Importjava.util.ArrayList;Importjava.util.List;ImportJavax.imageio.ImageIO;ImportOrg.apache.poi.hssf.usermodel.HSSFCell;ImportOrg.apache.poi.hssf.usermodel.HSSFCellStyle;ImportOrg.apache.poi.hssf.usermodel.HSSFClientAnchor;ImportOrg.apache.poi.hssf.usermodel.HSSFFont;ImportOrg.apache.poi.hssf.usermodel.HSSFPatriarch;ImportOrg.apache.poi.hssf.usermodel.HSSFRow;ImportOrg.apache.poi.hssf.usermodel.HSSFSheet;ImportOrg.apache.poi.hssf.usermodel.HSSFWorkbook; Public classTestexcelimage {Staticlist<bufferedimage> images =NewArraylist<bufferedimage>();Static {    Try{images.add (Imageio.read (NewFile ("D:\\eee.png"))); } Catch(IOException e) {e.printstacktrace (); }}     Public Static voidMain (string[] args) {FileOutputStream fileout=NULL; Try {            //Create a workbookHssfworkbook WB =NewHssfworkbook (); Hssfsheet Sheet1= Wb.createsheet ("New Sheet"); //Hssfrow row = Sheet1.createrow (2);Hssfpatriarch Patriarch =Sheet1.createdrawingpatriarch ();  Shorti = 0;  for(BufferedImage image:images) {bytearrayoutputstream bytearrayout=NewBytearrayoutputstream (); Imageio.write (Image,"JPG", bytearrayout); Hssfclientanchor Anchor=NewHssfclientanchor (0, 0, 0, 0, ( Short) 1, 1 + I, ( Short) 2, 2 +i); Anchor.setanchortype (0); //Insert PicturePatriarch.createpicture (anchor, Wb.addpicture (Bytearrayout.tobytearray (), hssfworkbook.picture_type_jpeg))            ; I++; } Hssfrow Row= Sheet1.createrow (10);  Shorts = 10; Hssfcell Cell=Row.createcell (s); Hssfcellstyle style=Wb.createcellstyle (); Hssffont Font=Wb.createfont (); Font.setstrikeout (true);            Style.setfont (font);            Cell.setcellstyle (style); Cell.setcellvalue ("AAAAA"); Fileout=NewFileOutputStream ("D:/workbook.xls"); //writing to an Excel fileWb.write (fileout);        Fileout.close (); } Catch(IOException io) {io.printstacktrace (); System.out.println ("Io Erorr:" +io.getmessage ()); } finally {            if(Fileout! =NULL) {                Try{fileout.close (); } Catch(IOException e) {e.printstacktrace (); }            }        }        }}

JEECG Export Pictures to Excel