JAVA POI XSSFWorkbook Excel中插入图片

    /**
      * 在excel单元格中插入图片，一个单元格显示一张图片
      */
    private static void drawImage(XSSFWorkbook wb, XSSFSheet sheet, int curRowIdx, int curCol, XSSFRow row, JSONArray jsonArray){
        jsonArray = null == jsonArray? new JSONArray() : jsonArray;
        for(int a = 0; a < jsonArray.size(); a ++) {
            int idxColScreenShot = curCol;
            String imageUrl = jsonArray.getString(a);
            byte[] data = getImageData(imageUrl);
            if(null != data) {
                XSSFDrawing drawingPatriarch = sheet.createDrawingPatriarch();
                //一个单元格插入一张图片，图片与单元格边框留5格像素的距离
                XSSFClientAnchor anchor = new XSSFClientAnchor(XSSFShape.EMU_PER_PIXEL * 5, XSSFShape.EMU_PER_PIXEL * 5, XSSFShape.EMU_PER_PIXEL * (-5), XSSFShape.EMU_PER_PIXEL * (-5), (short)idxColScreenShot + a, curRowIdx, (short) idxColScreenShot + a+1, curRowIdx+1);
                anchor.setAnchorType(AnchorType.MOVE_AND_RESIZE);
                drawingPatriarch.createPicture(anchor, wb.addPicture(data, XSSFWorkbook.PICTURE_TYPE_PNG));
            } else {
                //图片已经不存在时这样处理？
                genNormalCell(wb, row, idxColScreenShot + a, "NOT FOUND: "+jsonArray.getString(a));
            }
            sheet.setColumnWidth(idxColScreenShot + a, 6750);
        }
        if(jsonArray.size() > 0) {
            row.setHeight((short)5550);
        }
    }

    private static XSSFCell genNormalCell(XSSFWorkbook wb, XSSFRow titleRow, int columnIdx, String cellValue){
        XSSFCell cell = titleRow.createCell(columnIdx);
        cell.setCellValue(new XSSFRichTextString(StringUtils.isBlank(cellValue)?"":cellValue));
        XSSFCellStyle style = getWhiteBgSytle(wb);
        cell.setCellStyle(style);
        return cell;
    }

    private static XSSFCellStyle getWhiteBgSytle (XSSFWorkbook xworkbook) {
        //设置样式
        XSSFCellStyle style = genBaseStyle(xworkbook, new XSSFColor(new Color(255,255,255)), new XSSFColor(new Color(242,242,242)));
        //设置字体
        XSSFFont font = genFontStyle(xworkbook);
        font.setFontHeightInPoints((short) 11);
        font.setFontName("微软雅黑 Light");
        style.setFont(font);
        return style;
    }

    private static XSSFCellStyle genBaseStyle(XSSFWorkbook xworkbook, XSSFColor bgColor, XSSFColor borderColor) {
        //设置样式
        XSSFCellStyle style = xworkbook.createCellStyle();
        //设置填充方案
        style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        //设置自定义填充颜色
        if(null != bgColor) {
            style.setFillForegroundColor(bgColor);
        }
        //设置一个细边框
        if(null != borderColor) {
            style.setBorderTop(BorderStyle.THIN);
            style.setBorderBottom(BorderStyle.THIN);
            style.setBorderLeft(BorderStyle.THIN);
            style.setBorderRight(BorderStyle.THIN);
            style.setBorderColor(BorderSide.TOP, borderColor);
            style.setBorderColor(BorderSide.BOTTOM, borderColor);
            style.setBorderColor(BorderSide.LEFT, borderColor);
            style.setBorderColor(BorderSide.RIGHT, borderColor);
        }
        //启动单元格内换行
        style.setWrapText(true);
        style.setVerticalAlignment(VerticalAlignment.CENTER);//垂直居中
        return style;
    }

    /**
     * 将本地图片／图片url链接，转化成byte[]
     * @param filePath
     * @return
     */
    public static byte[] getImageData(String filePath){
        if(!checkImageContain(filePath)){
            return null;
        }
        ByteArrayOutputStream baos = new ByteArrayOutputStream();
        InputStream inStream = null;
        try {
            String tmpStr = filePath.toUpperCase();
            if(tmpStr.startsWith("HTTP://") || tmpStr.startsWith("HTTPS://") || tmpStr.startsWith("//")) {
                //但给的图片地址是url时
                URL httpUrl = new URL(filePath);
                HttpURLConnection conn = (HttpURLConnection)httpUrl.openConnection();
                conn.setRequestMethod("GET");
                conn.setConnectTimeout(5 * 1000);
                try {
                    inStream = conn.getInputStream();//通过输入流获取图片数据
                    if (null == inStream) {
                        return null;
                    }
                } catch (FileNotFoundException e) {
                    log.error("getImageData({}) : ", filePath, e);
                    return null;
                }
                //从输入流中获取数据
                byte[] buffer = new byte[1024];
                int len = 0;
                while( (len=inStream.read(buffer)) != -1 ){
                    baos.write(buffer, 0, len);
                }
                byte[] data = baos.toByteArray();
                return data;
            } else {
                BufferedImage bufferedImage = ImageIO.read(new File(filePath));
                String suffix = getSuffix(filePath);
                suffix = null == suffix? "png":suffix;
                ImageIO.write(bufferedImage, suffix, baos);
                byte[] data = baos.toByteArray();
                return data;
            }
        } catch (Exception e) {
            log.error("getImageData({}) : ", filePath, e);
        } finally {
            try {
                if(null != inStream) {
                    inStream.close();
                }
                baos.close();
            } catch (Exception e) {
                log.error("getImageData({}) fail to close(): ", filePath, e);
            }
        }
        return null;
    }