Spire.XLS for Java 5.3.1已发布。该版本支持创建瀑布图、Pareto直方图、直方图、箱形图、树状图、旭日图、漏斗图,并增强了Excel到PDF、Excel到图片的转换功能。同时修复了获取的签名信息不正确等已知问题。详情请阅读以下内容。 新功能: 支持创建瀑布图。 Workbookworkbook=newWorkbook(); workbook.loadFromFile("input.xlsx"); Worksheetsheet=workbook.getWorksheets().get(0); ChartofficeChart=sheet.getCharts().add(); //Setcharttypeaswaterfall officeChart.setChartType(ExcelChartType.WaterFall); //Setdatarangetothechartfromtheworksheet officeChart.setDataRange(sheet.getRange().get("A2:B8")); //Datapointsettingsastotalinchart officeChart.getSeries().get(0).getDataPoints().get(3).setAsTotal(true); officeChart.getSeries().get(0).getDataPoints().get(6).setAsTotal(true); //Showingtheconnectorlinesbetweendatapoints officeChart.getSeries().get(0).getFormat().showConnectorLines(true); //Setthecharttitle officeChart.setChartTitle("CompanyProfit(inUSD)"); //Formattingdatalabelandlegendoption officeChart.getSeries().get(0).getDataPoints().getDefaultDataPoint().getDataLabels().hasValue(true); officeChart.getSeries().get(0).getDataPoints().getDefaultDataPoint().getDataLabels().setSize(8); officeChart.getLegend().setPosition(LegendPositionType.Right); workbook.saveToFile("output.xlsx",FileFormat.Version2016); 支持创建Pareto直方图。 Workbookworkbook=newWorkbook(); workbook.loadFromFile("input.xlsx"); Worksheetsheet=workbook.getWorksheets().get(0); ChartofficeChart=sheet.getCharts().add(); //SetcharttypeasPareto officeChart.setChartType(ExcelChartType.Pareto); //Setdatarangeintheworksheet officeChart.setDataRange(sheet.getRange().get("A2:B8")); //Setcategoryvaluesasbinvalues…