我使用的是POI 3.12-beta1,并且代碼可以在圖例中創(chuàng)建包含多個數(shù)據(jù)集和命名系列的折線圖.但是,poi中折線圖的默認設(shè)置會生成一條已在數(shù)據(jù)點上平滑的線.空值也被繪制為0,但我們希望這些線在第一列停止,其中有一個空單元格.

一旦在xlsx文件中呈現(xiàn)并更改這些設(shè)置,我就可以進入圖表屬性,但我們需要使用這些設(shè)置渲染xlsx.我在可用的API中找不到任何更改這些設(shè)置的內(nèi)容.

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 });

總結(jié)

以上是生活随笔為你收集整理的java窗体线条切换消失_java – 如何更改apache poi生成的图表不使用平滑线条并将空单元格显示为间隙？...的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。