Examples with POIXMLDocumentPart org.apache.poi.ooxml.POIXMLDocumentPart used on opensource projects

Example 1 with POIXMLDocumentPart

use of org.apache.poi.ooxml.POIXMLDocumentPart in project hutool by looly.

the class ExcelPicUtil method getPicMapXlsx.

/**
 * 获取XLSX工作簿指定sheet中图片列表
 *
 * @param workbook 工作簿{@link Workbook}
 * @param sheetIndex sheet的索引
 * @return 图片映射，键格式：行_列，值：{@link PictureData}
 */
private static Map<String, PictureData> getPicMapXlsx(XSSFWorkbook workbook, int sheetIndex) {
    final Map<String, PictureData> sheetIndexPicMap = new HashMap<>();
    final XSSFSheet sheet = workbook.getSheetAt(sheetIndex);
    XSSFDrawing drawing;
    for (POIXMLDocumentPart dr : sheet.getRelations()) {
        if (dr instanceof XSSFDrawing) {
            drawing = (XSSFDrawing) dr;
            final List<XSSFShape> shapes = drawing.getShapes();
            XSSFPicture pic;
            CTMarker ctMarker;
            for (XSSFShape shape : shapes) {
                if (shape instanceof XSSFPicture) {
                    pic = (XSSFPicture) shape;
                    ctMarker = pic.getPreferredSize().getFrom();
                    sheetIndexPicMap.put(StrUtil.format("{}_{}", ctMarker.getRow(), ctMarker.getCol()), pic.getPictureData());
                }
            // 其他类似于图表等忽略，see: https://gitee.com/loolly/hutool/issues/I38857
            }
        }
    }
    return sheetIndexPicMap;
}