org.apache.poi.POIXMLDocumentPart Java Exaples

Source File: PoiPublicUtil.java From autopoi with Apache License 2.0

6 votes

/**
 * 获取Excel2007图片
 * 
 * @param sheet
 *            当前sheet对象
 * @param workbook
 *            工作簿对象
 * @return Map key:图片单元格索引（1_1）String，value:图片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues07(XSSFSheet sheet, XSSFWorkbook workbook) {
	Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
	for (POIXMLDocumentPart dr : sheet.getRelations()) {
		if (dr instanceof XSSFDrawing) {
			XSSFDrawing drawing = (XSSFDrawing) dr;
			List<XSSFShape> shapes = drawing.getShapes();
			for (XSSFShape shape : shapes) {
				XSSFPicture pic = (XSSFPicture) shape;
				XSSFClientAnchor anchor = pic.getPreferredSize();
				CTMarker ctMarker = anchor.getFrom();
				String picIndex = ctMarker.getRow() + "_" + ctMarker.getCol();
				sheetIndexPicMap.put(picIndex, pic.getPictureData());
			}
		}
	}
	return sheetIndexPicMap;
}

Source File: PoiPublicUtil.java From jeasypoi with Apache License 2.0

6 votes

/**
 * 获取Excel2007图片
 * 
 * @param sheet
 *            当前sheet对象
 * @param workbook
 *            工作簿对象
 * @return Map key:图片单元格索引（1_1）String，value:图片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues07(XSSFSheet sheet, XSSFWorkbook workbook) {
	Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
	for (POIXMLDocumentPart dr : sheet.getRelations()) {
		if (dr instanceof XSSFDrawing) {
			XSSFDrawing drawing = (XSSFDrawing) dr;
			List<XSSFShape> shapes = drawing.getShapes();
			for (XSSFShape shape : shapes) {
				XSSFPicture pic = (XSSFPicture) shape;
				XSSFClientAnchor anchor = pic.getPreferredSize();
				CTMarker ctMarker = anchor.getFrom();
				String picIndex = ctMarker.getRow() + "_" + ctMarker.getCol();
				sheetIndexPicMap.put(picIndex, pic.getPictureData());
			}
		}
	}
	return sheetIndexPicMap;
}

Source File: PoiPublicUtil.java From easypoi with Apache License 2.0

6 votes

/**
 * 获取Excel2007图片
 * 
 * @param sheet
 *            当前sheet对象
 * @param workbook
 *            工作簿对象
 * @return Map key:图片单元格索引（1_1）String，value:图片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues07(XSSFSheet sheet, XSSFWorkbook workbook) {
    Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
    for (POIXMLDocumentPart dr : sheet.getRelations()) {
        if (dr instanceof XSSFDrawing) {
            XSSFDrawing drawing = (XSSFDrawing) dr;
            List<XSSFShape> shapes = drawing.getShapes();
            for (XSSFShape shape : shapes) {
                XSSFPicture pic = (XSSFPicture) shape;
                XSSFClientAnchor anchor = pic.getPreferredSize();
                CTMarker ctMarker = anchor.getFrom();
                String picIndex = ctMarker.getRow() + "_" + ctMarker.getCol();
                sheetIndexPicMap.put(picIndex, pic.getPictureData());
            }
        }
    }
    return sheetIndexPicMap;
}

Source File: PptTemplates.java From PPT-Templates with Apache License 2.0

6 votes

/**
 * Replace an image with another while keeping
 * all the properties of the old image: z-index, border, shadow...
 */
private static void replaceImageInPlace(POIXMLDocumentPart containerDocument, ImageToReplace imageToReplace,
		XSLFPictureData newPictureData, Rectangle2D newImageAnchor) {
	RelationPart rp = containerDocument.addRelation(null, XSLFRelation.IMAGES, newPictureData);
	CTPicture pictureXml = (CTPicture) imageToReplace.toReplace.getXmlObject();
	CTBlip pictureBlip = pictureXml.getBlipFill().getBlip();

	String relationId = pictureBlip.getEmbed();
	if(canRelationBeRemoved(containerDocument, relationId)) {
		// clean up the old picture data
		PptPoiBridge.removeRelation(containerDocument, containerDocument.getRelationById(relationId));
	}

	pictureBlip.setEmbed(rp.getRelationship().getId());

	imageToReplace.toReplace.setAnchor(newImageAnchor);
}

Source File: ExcelPublicUtil.java From jeewx with Apache License 2.0

6 votes

/** 
 * 获取Excel2007图片 
 * @param sheet 当前sheet对象
 * @param workbook 工作簿对象 
 * @return Map key:图片单元格索引（1_1）String，value:图片流PictureData 
 */  
public static Map<String, PictureData> getSheetPictrues07(  
        XSSFSheet sheet, XSSFWorkbook workbook) {  
    Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();  
    for (POIXMLDocumentPart dr : sheet.getRelations()) {  
        if (dr instanceof XSSFDrawing) {  
            XSSFDrawing drawing = (XSSFDrawing) dr;  
            List<XSSFShape> shapes = drawing.getShapes();  
            for (XSSFShape shape : shapes) {  
                XSSFPicture pic = (XSSFPicture) shape;  
                XSSFClientAnchor anchor = pic.getPreferredSize();  
                CTMarker ctMarker = anchor.getFrom();  
                String picIndex = ctMarker.getRow() + "_" + ctMarker.getCol();  
                sheetIndexPicMap.put(picIndex, pic.getPictureData());  
            }  
        }  
    }  
    return sheetIndexPicMap;  
}

Source File: ConfigResolver.java From hui-core-autoreport with Apache License 2.0

5 votes

/**
 * 获取表格数据.
 *
 * @param chart     the chart
 * @param paramsMap the params map
 * @return the data map
 * @throws IOException the io exception
 * @since hui_project 1.0.0
 */
public List<ChartSeries> getDataMap(XSLFChart chart, Map<String, Object> paramsMap) throws IOException {
    POIXMLDocumentPart excelPart = chart.getRelations().get(0);
    InputStream excelInputStream = excelPart.getPackagePart().getInputStream();
    Workbook workbook = new XSSFWorkbook(excelInputStream);
    Sheet sheet = workbook.getSheetAt(0);
    String config = sheet.getRow(25).getCell(25).getStringCellValue();
    excelInputStream.close();
    workbook.close();
    Map<String, String> configMap = getConfig(config);
    String sql = "";
    Map<String, String> colRowValueMap = new HashMap<>();
    for (String key : configMap.keySet()) {
        if (CHART_SQL.equals(key)) {
            sql = configMap.get(key);
        } else if (CHART_COL_ROW_VALUE.equals(key)) {
            String colRowValue = configMap.get(key);
            String colRowValueArray[] = colRowValue.split(":");
            for (String s : colRowValueArray) {
                String mapKey = s.substring(0, s.indexOf(","));
                String mapValue = s.substring(s.indexOf(",") + 1, s.length());
                colRowValueMap.put(mapKey, mapValue);
            }
        }

    }
    return analysisGraphData(sql, colRowValueMap, paramsMap);
}

Source File: WordTableCellContentOleObject.java From sun-wordtable-read with Apache License 2.0

5 votes

/**
 * 读取Ole对象
 * 
 * @param embedId
 * @param xdoc
 * @return
 */
private WcOleObject readOleObject(String embedId, final XWPFDocument xdoc) {
	if (StringUtils.isBlank(embedId)) {
		return null;
	}
	WcOleObject oleObject = null;
	List<POIXMLDocumentPart> parts = xdoc.getRelations();
	for (POIXMLDocumentPart poixmlDocumentPart : parts) {
		String id = poixmlDocumentPart.getPackageRelationship().getId();
		if (embedId.equals(id)) {
			PackagePart packagePart = poixmlDocumentPart.getPackagePart();

			oleObject = new WcOleObject();
			// oleObjectContent.setFileName(packagePart.getPartName().getName());

			// 解析Ole对象中的文件，参考：http://poi.apache.org/poifs/how-to.html
			try (InputStream is = packagePart.getInputStream();) {
				POIFSFileSystem poifs = new POIFSFileSystem(is);

				if (isOle10NativeObject(poifs.getRoot())) {
					oleObject = readOle10Native(poifs);
				} else {
					oleObject = readDocumentOle(poifs, is);
				}
			} catch (Exception e) {
				logger.error(e.getMessage(), e);
			}
		}
	}

	return oleObject;
}

Source File: PptTemplates.java From PPT-Templates with Apache License 2.0

5 votes

private static boolean canRelationBeRemoved(POIXMLDocumentPart containerDocument, String relationId) {
	XSLFSlide currentSlide = findCurrentSlide(containerDocument);
	if(currentSlide == null) {
		// this case where a containerDocument in not part of a slide should not append,
		// but in doubt we don't allow relation to be changed here
		return false;
	}

	return StringUtils.countMatches(currentSlide.getXmlObject().toString(), "r:embed=\""+relationId+"\"") < 2;
}

Source File: PptTemplates.java From PPT-Templates with Apache License 2.0

5 votes

private static XSLFSlide findCurrentSlide(POIXMLDocumentPart containerDocument) {
	while(containerDocument != null) {
		if(containerDocument instanceof XSLFSlide) {
			return (XSLFSlide) containerDocument;
		}
		if(containerDocument instanceof XMLSlideShow) {
			return null;
		}

		containerDocument = containerDocument.getParent();
	}
	return null;
}

Source File: ConfigResolver.java From hui-core-autoreport with Apache License 2.0

4 votes

/**
 * 读取每页配置文件.
 *
 * @param slide     the slide
 * @param paramsMap the params map
 * @return the slide data
 * @throws IOException the io exception
 * @since hui_project 1.0.0
 */
private SlideData loadSlideConfig(XSLFSlide slide, Map<String, Object> paramsMap) throws IOException {
    SlideData slideData = new SlideData();
    List<ChartData> chartDataList = new ArrayList<>();
    Map<String, String> textMap = new HashMap<>();
    List<TableData> tableDataList = new ArrayList<>();

    List<POIXMLDocumentPart> partList = slide.getRelations();
    for (POIXMLDocumentPart part : partList) {
        if (part instanceof XSLFChart) {
            List<ChartSeries> seriesDataList = getDataMap((XSLFChart) part, paramsMap);
            ChartData chartData = new ChartData();
            chartData.setChartSeriesList(seriesDataList);
            chartDataList.add(chartData);
        }
    }

    List<XSLFShape> shapeList = slide.getShapes();

    for (XSLFShape shape : shapeList) {

        //判断文本框
        if (shape instanceof XSLFTextShape) {
            Map<String, String> tempMap = getDataMap((XSLFTextShape) shape,paramsMap);
            textMap.putAll(tempMap);
        }
        //判断表格
        if (shape instanceof XSLFTable) {
            List<TableRowData> tempList = getDataMap((XSLFTable) shape);
            TableData tableData = new TableData();
            tableData.setTableRowDataList(tempList);
            tableDataList.add(tableData);
        }
    }
    slideData.setTextMap(textMap);
    slideData.setTableDataList(tableDataList);
    slideData.setChartDataList(chartDataList);
    slideData.setSlidePage(slide.getSlideNumber());

    return slideData;
}

Source File: PowerPointGenerator.java From hui-core-autoreport with Apache License 2.0

4 votes

/**
 * 替换每一页数据
 *
 * @param slide
 * @param slideData
 * @throws IOException
 */
private static void generatorSlide(XSLFSlide slide, SlideData slideData) {
    List<POIXMLDocumentPart> partList = slide.getRelations();
    //当一页有多个图表的时候
    int chartNum = 0;
    for (POIXMLDocumentPart part : partList) {
        if (part instanceof XSLFChart) {
            ChartData chartData = slideData.getChartDataList().get(chartNum);
            if (chartData == null) {
                throw new ReportExcetion(ReportErrorEnum.CHART_DATA_ERROR.getMsg());
            }
            List<ChartSeries> seriesDataList = chartData.getChartSeriesList();
            if (seriesDataList == null) {
                throw new ReportExcetion(ReportErrorEnum.CHART_SERIER_DATA_ERROR.getMsg());
            }
            //构造PPT
            generatorChart((XSLFChart) part, seriesDataList);
            chartNum++;
        }
    }


    List<XSLFShape> shapeList = slide.getShapes();

    for (XSLFShape shape : shapeList) {
        Map<String, String> textMap = slideData.getTextMap();
        List<TableData> tableDataList = slideData.getTableDataList();
        //当一页有多个表格的时候
        int tableNum = 0;
        //判断文本框
        if (shape instanceof XSLFTextShape) {
            generatorTextBox((XSLFTextShape) shape, textMap);
        }
        //判断表格
        if (shape instanceof XSLFTable) {
            List<TableRowData> tableRowDataList = tableDataList.get(tableNum).getTableRowDataList();
            generatorTable((XSLFTable) shape, tableRowDataList);

        }
        tableNum++;
    }

}

Source File: PptTemplates.java From PPT-Templates with Apache License 2.0

4 votes

private static void replaceImage(XMLSlideShow ppt, ShapeContainer<XSLFShape, ?> shapeContainer, ImageToReplace imageToReplace) {
	byte[] newPictureResized = imageToReplace.imageMapper.getReplacementMode().resize(
		imageToReplace.imageMapper.getValue(),
		imageToReplace.imageMapper.getTargetFormat().name(),
		(int) imageToReplace.toReplace.getAnchor().getWidth(),
		(int) imageToReplace.toReplace.getAnchor().getHeight(),
		imageToReplace.getImageMapper().getQualityFactory(),
		imageToReplace.getImageMapper().getQualityMultiplicator()
	);
	if(newPictureResized == null) {
		// if an error occurred during the resizement of the image, the replacement cannot be processed
		return;
	}

	XSLFPictureData newPictureData = ppt.addPicture(newPictureResized, imageToReplace.imageMapper.getTargetFormat());
	Rectangle2D newImageAnchor = computeNewImageAnchor(
		imageToReplace.toReplace.getAnchor(),
		newPictureResized,
		imageToReplace.imageMapper.getReplacementMode(),
		imageToReplace.imageMapper.getQualityMultiplicator()
	);

	if(shapeContainer instanceof POIXMLDocumentPart) {
		replaceImageInPlace((POIXMLDocumentPart) shapeContainer, imageToReplace, newPictureData, newImageAnchor);
	}
	else if(shapeContainer instanceof XSLFGroupShape) {
		replaceImageInPlace(((XSLFGroupShape) shapeContainer).getSheet(), imageToReplace, newPictureData, newImageAnchor);
	}
	// If the container is not a POIXMLDocumentPart or a XSLFGroupShape,
	// the old image have to deleted along with its properties.
	// The new image will just be place in the same area of the old image.
	// This behavior is a fall back that should not append since
	// I don't think the image container can be something else
	// apart from POIXMLDocumentPart and XSLFGroupShape.
	else {
		XSLFPictureShape newPictureShape = (XSLFPictureShape) shapeContainer.createPicture(newPictureData);
		newPictureShape.setAnchor(newImageAnchor);

		shapeContainer.removeShape(imageToReplace.toReplace);
	}
}

org.apache.poi.POIXMLDocumentPart Java Examples