网站建设春节放假,wordpress免费模版安装教程,不愁销路的小型加工厂项目年入百万,苏州360推广 网站建设我使用的是POI 3.12-beta1,并且代码可以在图例中创建包含多个数据集和命名系列的折线图.但是,poi中折线图的默认设置会生成一条已在数据点上平滑的线.空值也被绘制为0,但我们希望这些线在第一列停止,其中有一个空单元格.一旦在xlsx文件中呈现并更改这些设置,我就可以进入图表属…我使用的是POI 3.12-beta1,并且代码可以在图例中创建包含多个数据集和命名系列的折线图.但是,poi中折线图的默认设置会生成一条已在数据点上平滑的线.空值也被绘制为0,但我们希望这些线在第一列停止,其中有一个空单元格.一旦在xlsx文件中呈现并更改这些设置,我就可以进入图表属性,但我们需要使用这些设置渲染xlsx.我在可用的API中找不到任何更改这些设置的内容.Drawing drawing sheet.createDrawingPatriarch();ClientAnchor anchor drawing.createAnchor(0, 0, 0, 0, 0, 17, 18, 30);Chart chart drawing.createChart(anchor);ChartLegend legend chart.getOrCreateLegend();legend.setPosition(LegendPosition.RIGHT);LineChartData data chart.getChartDataFactory().createLineChartData();ChartAxis bottomAxis chart.getChartAxisFactory().createCategoryAxis(AxisPosition.BOTTOM);ValueAxis leftAxis chart.getChartAxisFactory().createValueAxis(AxisPosition.LEFT);leftAxis.setCrosses(AxisCrosses.AUTO_ZERO);int row 2;int startCol 3;int endCol 17;boolean abs false;ChartDataSource xs DataSources.fromNumericCellRange(sheet, new CellRangeAddress(row, row, startCol, endCol));row 10;int seriesCol 0;ChartDataSource ys1 DataSources.fromNumericCellRange(sheet, new CellRangeAddress(row, row, startCol, endCol));LineChartSerie ser1 data.addSerie(xs, ys1);ser1.setTitle(new CellReference(sheet.getSheetName(), row, seriesCol, abs, abs));row 11;ChartDataSource ys2 DataSources.fromNumericCellRange(sheet, new CellRangeAddress(row, row, startCol, endCol));LineChartSerie ser2 data.addSerie(xs, ys2);ser2.setTitle(new CellReference(sheet.getSheetName(), row, seriesCol, abs, abs));row 12;ChartDataSource ys3 DataSources.fromNumericCellRange(sheet, new CellRangeAddress(row, row, startCol, endCol));LineChartSerie ser3 data.addSerie(xs, ys3);ser3.setTitle(new CellReference(sheet.getSheetName(), row, seriesCol, abs, abs));chart.plot(data, new ChartAxis[] { bottomAxis, leftAxis });
