要支持复制行图片,你需要对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:
// 如果是空白单元格,则直接设置为空白类型
targetCell.setBlank();
break;
default:
// 默认处理
}
// 复制图片(如果有)
List<? extends PictureData> pictures = workbook.getAllPictures();
for (PictureData picture : pictures) {
if (picture instanceof XSSFPictureData) {
XSSFDrawing drawing = ((XSSFSheet) source.getSheet()).getDrawingPatriarch();
if (drawing != null) {
XSSFClientAnchor anchor = getAnchorFromCell(sourceCell);
XSSFPicture sourcePicture = findPictureByCoordinates(drawing, anchor);
if (sourcePicture != null) {
byte[] pictureData = picture.getData();
int pictureIndex = workbook.addPicture(pictureData, Workbook.PICTURE_TYPE_PNG);
CreationHelper helper = workbook.getCreationHelper();
Drawing targetDrawing = ((XSSFSheet) target.getSheet()).createDrawingPatriarch();
ClientAnchor targetAnchor = helper.createClientAnchor();
targetAnchor.setCol1(anchor.getCol1());
targetAnchor.setRow1(target.getRowNum());
Picture targetPicture = targetDrawing.createPicture(targetAnchor, pictureIndex);
targetPicture.resize(); // 调整图片大小(可选)
}
}
}
}
}
}
}
private XSSFClientAnchor getAnchorFromCell(Cell cell) {
Drawing drawing = ((XSSFSheet) cell.getSheet()).getDrawingPatriarch();
for (XSSFShape shape : drawing.getShapes()) {
if (shape instanceof XSSFPicture) {
XSSFPicture picture = (XSSFPicture) shape;
CTMarker markerFromPic = picture.getCTPicture().getNvPicPr().getCNvPicPr().getFrom().getMarker();
if (markerFromPic.getRow() == cell.getRowIndex() && markerFromPic.getCol() == cell.getColumnIndex()) {
return picture.getClientAnchor();
}
}
}
return null;
}
private XSSFPicture findPictureByCoordinates(XSSFDrawing drawing, XSSFClientAnchor anchor) {
List<XSSFShape> shapes = drawing.getShapes();
for (XSSFShape shape : shapes) {
if (shape instanceof XSSFPicture) {
XSSFPicture picture = (XSSFPicture) shape;
XSSFClientAnchor pictureAnchor = picture.getClientAnchor();
if (pictureAnchor.getCol1() == anchor.getCol1()
&& pictureAnchor.getRow1() == anchor.getRow1()) {
return picture;
}
}
}
return null;
}
请注意,上述修改假设你正在使用Apache POI的XSSFWorkbook和XSSFSheet来处理Excel文件,并且图片格式为PNG。如果使用其他库或图片格式,请根据实际情况进行相应的调整。此外,复制行时只能复制同一工作簿内的图片。
内容由零声教学AI助手提供,问题来源于学员提问