Java导出excel包含图片 并将图片嵌入单元格

在Java中，你可以使用Apache POI库（poi-ooxml-schemas和poi-ooxml）配合XSSF或SXSSFWorkbook来创建Excel文件并将其内容包括图片嵌入到单元格中。以下是简单的步骤：

1. **添加依赖**:
首先，在你的项目中引入Apache POI相关的jar包，例如通过Maven：

   <dependency>
       <groupId>org.apache.poi</groupId>
       <artifactId>poi-ooxml</artifactId>
       <version>最新版本号</version>
   </dependency>

2. **创建工作簿和单元格**:

   import org.apache.poi.xssf.usermodel.XSSFWorkbook;
   Workbook workbook = new XSSFWorkbook();
   Sheet sheet = workbook.createSheet("Sheet1");
   Row row = sheet.createRow(0);
   Cell cell = row.createCell(0); // 单元格位置

3. **加载图片**:

   FileInputStream imageStream = new FileInputStream("path_to_your_image.jpg");
   byte[] imageData = IOUtils.toByteArray(imageStream);
   ImageFactory imageFactory = ImageFactory.getInstance();
   Drawing<?> drawing = sheet.createDrawingPatriarch();
   Picture pic = drawing.addPicture(imageData, ImageType.PICTURE_TYPE_JPEG);

4. **将图片插入单元格**:

   cell.setCellStyle(styleWithImage); // 创建带图片的样式
   clientAnchor = drawing.createAnchor(0, 0, pic.getWidth(), pic.getHeight(), row.getPhysicalLocation().x, row.getPhysicalLocation().y,
         row.getLastCellNum() * columnWidth + row.getPhysicalLocation().x, row.getLastCellNum() * columnWidth + row.getPhysicalLocation().y);
   pic.setAnchor(clientAnchor);
   cell.setCellValue("Your text here"); // 添加文字描述图片

5. **保存文件**:

   try (OutputStream outputStream = new FileOutputStream("output.xlsx")) {
       workbook.write(outputStream);
   } catch (IOException e) {
       e.printStackTrace();
   }