excel---hssf
excel通过HSSFChart实例的getType方法来获取图表的类型。其返回值是HSSFChart.HSSFChartType，定义为：
public static enum HSSFChartType {Area {public short getSid() {return (short)4122;}},Bar {public short getSid() {return (short)4119;}},Line {public short getSid() {return (short)4120;}},Pie {public short getSid() {return (short)4121;}},Scatter {public short getSid() {return (short)4123;}},Unknown {public short getSid() {return (short)0;}};private HSSFChartType() {}public abstract short getSid();}
更多属性可参见：/starandsea/article/details/51740673
excel--xssf
excel和ppt使用org.openxmlformats.schemas.drawingml.x.chart.CTChart这个类来判断图表的类型。通过CTChart中的CTPlotArea属性，CTPlotArea有一组方法getPieChartList、getLineChartList、getBarChartList等分别判断饼图、线形图、柱状图的数量，如果是图表是饼图，那么getPieChartList这个list的长度是1，其他的都是0，如果是线形图，getLineChartList这个方法获取的list长度是1，其他都是0。示例代码：
public static void readChart2() throws Exception {File excelFile = new File("e:/excel-chart.xlsx");XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream(excelFile));//获取第一个sheetXSSFSheet sheet = workbook.getSheet(workbook.getSheetName(0));//获取sheet的所有图表XSSFDrawing dw = sheet.getDrawingPatriarch();List<XSSFChart> cs = dw.getCharts();for (XSSFChart c : cs) {//获取CTChartCTChart ctChart = c.getCTChart();CTPlotArea plotArea = ctChart.getPlotArea();System.out.println("pie" + plotArea.getPieChartList().size());System.out.println("line" + plotArea.getLineChartList().size());System.out.println("bar" + plotArea.getBarChartList().size());System.out.println("scatter" + plotArea.getScatterChartList().size());}}
ppt--hslf
hslf中没有发现有操作ppt图表的类。
ppt--xslf
获取方法同上面说的excel。示例代码：
public static void readChart3() throws Exception{//打开模板pptXMLSlideShow pptx = new XMLSlideShow(new FileInputStream("e:/ppt-chart.pptx"));//获取第一个ppt页面XSLFSlide slide = pptx.getSlides().get(0);//遍历第一页元素找到图表for(POIXMLDocumentPart part : slide.getRelations()){if(part instanceof XSLFChart){XSLFChart chart = (XSLFChart) part;CTChart ctChart = chart.getCTChart();CTPlotArea plotArea = ctChart.getPlotArea();System.out.println("pie" + plotArea.getPieChartList().size());System.out.println("line" + plotArea.getLineChartList().size());System.out.println("bar" + plotArea.getBarChartList().size());System.out.println("scatter" + plotArea.getScatterChartList().size());}}}
