关键代码如下:
HSSFWorkbook workbook = new HSSFWorkbook();HSSFSheet sheet = workbook.createSheet("sheet1");// fileName为图片完整路径,例:C:\images\EDG.jpgInputStream 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;
如果觉得《Apache POI 在Excel单元格嵌入图片》对你有帮助,请点赞、收藏,并留下你的观点哦!