POI抓取PPT图表页图表标题

最新推荐文章于 2024-07-24 09:52:29 发布

那只猫哭了

最新推荐文章于 2024-07-24 09:52:29 发布

阅读量1.2k

点赞数 1

分类专栏： spring

本文链接：https://blog.csdn.net/caoyang0105/article/details/84537850

版权

spring 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

应需求需要抓取PPT的图表标题，poi可以实现这个功能，PDFbox和itext也可以，但是后两者比较麻烦。

一、依赖

<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi</artifactId>
			<version>3.15</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>3.15</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-scratchpad</artifactId>
			<version>3.15</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>ooxml-schemas</artifactId>
			<version>1.3</version>
		</dependency>

二、代码

public static void main(String[] args) {
        try {
            XMLSlideShow ppt = new XMLSlideShow(new FileInputStream("C:\\Users\\Administrator\\Desktop\\a.pptx"));
            //循环幻灯片
            for (XSLFSlide S:ppt.getSlides()){
                for (POIXMLDocumentPart part :S.getRelations()){
                    //判断是否有chart
                    if(part instanceof XSLFChart){
                        XSLFChart chart = (XSLFChart) part;
                        CTChart ctChart = chart.getCTChart();
                        CTTitle title = ctChart.getTitle();
                        if(title == null)
                            continue;
                        CTTx titleTx = title.getTx();
                        CTTextBody body = titleTx.getRich();
                        CTTextParagraph[] paragraphs = body.getPArray();
                        for(int i=0; i<paragraphs.length; i++) {
                            CTTextParagraph paragraph = paragraphs[i];
                            CTRegularTextRun[] runs = paragraph.getRArray();

                            String chartTitle = "";
                            for(int j=0; j<runs.length; j++) {
                                CTRegularTextRun run = runs[j];
                                String t = run.getT();
                                chartTitle += t;
                            }
                            System.out.println(chartTitle);
                        }

                    }
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }