用Java將圖片寫入到Excel中

1. import java.awt.image.BufferedImage;
2. import java.io.ByteArrayOutputStream;
3. import java.io.File;
4. import java.io.FileOutputStream;
5. import java.io.IOException;
7. import javax.imageio.ImageIO;
9. import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
10. import org.apache.poi.hssf.usermodel.HSSFPatriarch;
11. import org.apache.poi.hssf.usermodel.HSSFSheet;
12. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
15. public class ExportPictureToExcel {
16.     public static void main(String args[]){
17.         exportChartToExcel();
18.     }
19.     
20.     private static void exportChartToExcel(){
21.         String excelFileName = "E://platoDemo.xls";
22.         String pictureFileName = "E://platoDemo.jpg";
23.         
24.         HSSFWorkbook wb = new HSSFWorkbook();
25.         HSSFSheet sheet = wb.createSheet();
26.                 
27.         ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
28.         try { 
29.             BufferedImage bufferImg = ImageIO.read(new File(pictureFileName));
30.                         
31.             ImageIO.write(bufferImg, "JPG", byteArrayOut);
32.             HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0,(short) 0, 0, (short) 10, 20);
33.             
34.             HSSFPatriarch patri = sheet.createDrawingPatriarch();
35.             patri.createPicture(anchor, wb.addPicture(byteArrayOut
36.                     .toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG));
37.             FileOutputStream outStream = new FileOutputStream(excelFileName);
38.             wb.write(outStream);
39.         } catch (IOException e) {
40.             // TODO Auto-generated catch block
41.             e.printStackTrace();
42.         }
43.     }  
44. }