关键代码如下:
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;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/202479.html原文链接:https://javaforall.net
