Apache POI 在Excel单元格嵌入图片

关键代码如下：

HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("sheet1");

// fileName为图片完整路径，例：C:\images\EDG.jpg
InputStream is = new FileInputStream(fileName);
byte[] bytes = IOUtils.toByteArray(is);

// 这里根据实际需求选择图片类型
int pictureIdx = workbook.addPicture(bytes, Workbook.PICTURE_TYPE_JPEG);

CreationHelper helper = workbook.getCreationHelper();
ClientAnchor anchor = helper.createClientAnchor();

Drawing drawing = sheet.createDrawingPatriarch();

anchor.setCol1(param1); // param1是列号
anchor.setRow1(param2); // param2是行号

// 插入图片
Picture pict = drawing.createPicture(anchor, pictureIdx);
// 调整图片占单元格百分比的大小，1.0就是100%
pict.resize(1.0);

return workbook;