要支持复制行图片,你需要对copyRow方法进行修改。下面是修改后的代码:
private void copyRow(Row source, Row target, Workbook workbook) {
// 遍历源行的每个单元格
for (int i = source.getFirstCellNum(); i <= source.getLastCellNum(); i++) {
Cell sourceCell = source.getCell(i);
// 如果源单元格为null,则不创建新单元格
if (sourceCell != null) {
Cell targetCell = target.createCell(i, sourceCell.getCellType());
// 复制单元格样式(如果需要)
CellStyle sourceCellStyle = sourceCell.getCellStyle();
CellStyle targetCellStyle = workbook.createCellStyle();
targetCellStyle.cloneStyleFrom(sourceCellStyle);
targetCell.setCellStyle(targetCellStyle);
// 根据单元格类型复制值
switch (sourceCell.getCellTypeEnum()) {
case STRING:
targetCell.setCellValue(sourceCell.getStringCellValue());
break;
case NUMERIC:
targetCell.setCellValue(sourceCell.getNumericCellValue());
break;
case BOOLEAN:
targetCell.setCellValue(sourceCell.getBooleanCellValue());
break;
case FORMULA:
// 如果单元格是公式,则复制公式本身
targetCell.setCellFormula(sourceCell.getCellFormula());
break;
case BLANK:
// target.setBlank();
break;
default:
// 默认处理
}
// 复制单元格中的图片(如果有)
List<? extends PictureData> pictures = workbook.getAllPictures();
for (PictureData picture : pictures) {
if (picture instanceof XSSFShapeGroup) {
XSSFDrawing drawingPatriarch = ((XSSFSheet) source.getSheet()).getDrawingPatriarch();
if (drawingPatriarch != null) {
XSSFDrawing targetDrawingPatriarch = ((XSSFSheet) target.getSheet()).createDrawingPatriarch();
for (XSSFShape shape : drawingPatriarch.getShapes()) {
if (shape instanceof XSSFPicture) {
XSSFPicture pictureSrc = (XSSFPicture) shape;
XSSFPicture pictureDest = targetDrawingPatriarch.createPicture(pictureSrc.getPreferredSize(), targetWorkbook.addPicture(pictureSrc.getPictureData().getData(), pictureSrc.getPictureType()));
XSSFClientAnchor anchor = pictureSrc.getClientAnchor();
pictureDest.getClientAnchor().setCol1(anchor.getCol1());
pictureDest.getClientAnchor().setRow1(target.getRowNum());
pictureDest.getClientAnchor().setDx1(anchor.getDx1());
pictureDest.getClientAnchor().setDy1(anchor.getDy1());
}
}
}
} else if (picture instanceof HSSFPictureData) {
// 处理HSSF格式的图片
}
}
}
}
}
上述代码修改了copyRow方法,新增了复制单元格中的图片的逻辑。请注意,这段代码是基于Apache POI库的,适用于处理Excel文件。对于其他类型的文档或表格文件格式,可能需要使用不同的库和方法来实现相应功能。
内容由零声教学AI助手提供,问题来源于学员提问




