Java inserts a picture into Excel

Java inserts a picture into Excel

2. Import Java.io.FileOutputStream;
4. Import Java.io.File;
6. Import Java.io.ByteArrayOutputStream;
8. Import java.io.IOException;
12. Import Java.awt.image.BufferedImage;
14. Import javax.imageio.*;
18. Import Org.apache.poi.hssf.usermodel.HSSFWorkbook;
20. Import Org.apache.poi.hssf.usermodel.HSSFSheet;
22. Import Org.apache.poi.hssf.usermodel.HSSFPatriarch;
24. import Org.apache.poi.hssf.usermodel.HSSFClientAnchor;;
28. Public class Testpoi {
32. public static void Main (string[] args) {
34. FileOutputStream fileout = null;
36. BufferedImage bufferimg =null;
38. BufferedImage BUFFERIMG1 = null;
40. try{
44. //First put the read in a bytearrayoutputstream in order to produce ByteArray
46. Bytearrayoutputstream bytearrayout = new Bytearrayoutputstream ();
48. Bytearrayoutputstream byteArrayOut1 = new Bytearrayoutputstream ();
50. bufferimg = Imageio.read (new File ("d:/piechart.jpg"));
52. BUFFERIMG1 = Imageio.read (new File ("d:/fruitbarchart.jpg"));
54. Imageio.write (bufferimg,"jpg", bytearrayout);
56. Imageio.write (BUFFERIMG1,"jpg", byteArrayOut1);
60. //Create a workbook
62. Hssfworkbook WB = new Hssfworkbook ();
64. Hssfsheet Sheet1 = Wb.createsheet ("new sheet");
66. //hssfrow row = Sheet1.createrow (2);
68. Hssfpatriarch Patriarch = Sheet1.createdrawingpatriarch ();
70. Hssfclientanchor anchor = New Hssfclientanchor (0,0,,255, (short) 1,1, (short)   ,20);
72. Hssfclientanchor Anchor1 = new Hssfclientanchor (0,0,,255, (short) 2,   ),60);
74. Anchor1.setanchortype (2);
76. //Insert Picture
78. Patriarch.createpicture (anchor, Wb.addpicture (Bytearrayout.tobytearray (), hssfworkbook.picture_type_jpeg));
80. Patriarch.createpicture (Anchor1, Wb.addpicture (Bytearrayout1.tobytearray (), hssfworkbook.picture_type_jpeg));
84. Fileout = new FileOutputStream ("D:/workbook.xls");
86. //write to Excel file
88. Wb.write (fileout);
90. Fileout.close ();
94. }catch (IOException io) {
96. Io.printstacktrace ();
98. System.out.println ("io Erorr:" + io.getmessage ());
100. } finally
102. {
104. if (fileout! = null)
106. {
110. try {
112. Fileout.close ();
114. }
116. catch (IOException e)
118. {
120. //TODO auto-generated catch block
122. E.printstacktrace ();
124. }
126. }
128. }
130. }
132. }

Java inserts a picture into Excel