excel动态的生成图片

        String templateFileFullName = request.getSession().getServletContext().getRealPath("/") + templateFileHome + "/" + templateFileName;
        InputStream is = new FileInputStream(templateFileFullName);
        XLSTransformer transformer = new XLSTransformer();
        HSSFWorkbook workBook = (HSSFWorkbook) transformer.transformXLS(is, params);
        HSSFSheet sheet = workBook.getSheetAt(0);
        HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
        String picture = request.getSession().getServletContext().getRealPath("/") + templateFileHome2 + "/images/iac_logo.png";
        for (int i = 0; i < outerSize; i++) {
            ByteArrayOutputStream bos = new ByteArrayOutputStream();
            BufferedImage BufferImg = ImageIO.read(new File(picture));
            ImageIO.write(BufferImg, "PNG", bos);
            HSSFClientAnchor anchor = new HSSFClientAnchor(10, 10, 0, 0, (short) 0, i * 38, (short) 3, i * 38 + 1);
            patriarch.createPicture(anchor, workBook.addPicture(bos.toByteArray(), Workbook.PICTURE_TYPE_PNG));
        }
        InputStream in = createExcelFile(workBook);
        String contentType = "application/vnd.ms-excel";
         down(response, in, contentType);
      
        protected InputStream createExcelFile(Workbook workBook) throws Exception {
        ByteArrayOutputStream out = null;
        InputStream in = null;
        try {
            out = new ByteArrayOutputStream();
            workBook.write(out);
            in = new ByteArrayInputStream(out.toByteArray());
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            IOUtils.closeQuietly(out);
        }
        return in;
    }

    private void down(HttpServletResponse response, InputStream in, String contentType) throws Exception {
        OutputStream os = response.getOutputStream();
        response.setContentType(contentType);
        response.setHeader("Content-Disposition", "attachment; filename=" + downloadFileName);
        response.setHeader("Content-Type", contentType + "text/x-download; charset=UTF-8");
        try {
            byte[] buf = new byte[1024];
            int size;
            while (-1 != (size = in.read(buf))) {
                os.write(buf, 0, size);
            }
            // Flush
            os.flush();
        } catch (Exception e) {
            throw new Exception("Something Wrong. In Class Of " + PickupExcelEntity.class.getName() + ".");
        } finally {
            IOUtils.closeQuietly(in);
            IOUtils.closeQuietly(os);
        }
    }