关键代码如下:
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;