excel2003---hssf
excel2003通过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();
}
更多属性可参见:http://blog.csdn.net/starandsea/article/details/51740673
excel2007--xssf
excel2007和ppt2007使用org.openxmlformats.schemas.drawingml.x2006.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));
//获取第一个sheet
XSSFSheet sheet = workbook.getSheet(workbook.getSheetName(0));
//获取sheet的所有图表
XSSFDrawing dw = sheet.getDrawingPatriarch();
List<XSSFChart> cs = dw.getCharts();
for (XSSFChart c : cs) {
//获取CTChart
CTChart 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());
}
}
ppt2003--hslf
hslf中没有发现有操作ppt图表的类。
ppt2007--xslf
获取方法同上面说的excel2007。示例代码:
public static void readChart3() throws Exception{
//打开模板ppt
XMLSlideShow 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());
}
}
}