如何使用Apache poi 4.1.2在Pie 3D Chart中设置自定义颜色 [英] how to set custom colors in pie 3D Chart using Apache poi 4.1.2
问题描述
我已经使用POI 4.1.2创建了PIE 3D图表.并且需要为每个图例条目使用特定的颜色期望如此
I have created PIE 3D chart using POI 4.1.2. and need to have specific colors for each legend entry expected like this
我使用的代码在这里,
final XSSFDrawing drawing = sheet2.createDrawingPatriarch();
final XSSFClientAnchor anchor =
drawing.createAnchor(0, 0, 0, 0, 0, 4, 7, 20);
final XSSFChart chart = drawing.createChart(anchor);
chart.setTitleText("Unit Build Procurement");
chart.setTitleOverlay(false);
final XDDFChartLegend legend = chart.getOrAddLegend();
legend.setPosition(LegendPosition.TOP_RIGHT);
final XDDFDataSource<String> dataSource =
XDDFDataSourcesFactory.fromStringCellRange(sheet2,
new CellRangeAddress(0, 0, 0, 3));
final XDDFNumericalDataSource<Double> values =
XDDFDataSourcesFactory.fromNumericCellRange(sheet2,
new CellRangeAddress(1, sheet2.getLastRowNum(), 0,
3));
final XDDFChartData data =
chart.createData(ChartTypes.PIE3D, null, null);
data.setVaryColors(true);
data.addSeries(dataSource, values);
chart.plot(data);
它会创建具有随机颜色的图表.
It creates chart with random colors.
提前感谢您的帮助.
推荐答案
到目前为止,尚无 XDDF
方法设置数据点颜色.只能使用 XDDF
方法设置系列颜色.因此,必须使用基础 org.openxmlformats.schemas.drawingml.x2006.chart.*
类.下面的完整示例显示了这一点.它从一堆先前设置的rgb字节数组中设置数据点颜色.
There is no XDDF
method to set data point colors until now. Only series colors can be set using XDDF
methods. So one must use the underlying org.openxmlformats.schemas.drawingml.x2006.chart.*
classes. Following complete example shows this. It sets data point colors from a bunch of formerly set rgb byte arrays.
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xddf.usermodel.chart.ChartTypes;
import org.apache.poi.xddf.usermodel.chart.LegendPosition;
import org.apache.poi.xddf.usermodel.chart.XDDFChartData;
import org.apache.poi.xddf.usermodel.chart.XDDFChartLegend;
import org.apache.poi.xddf.usermodel.chart.XDDFDataSource;
import org.apache.poi.xddf.usermodel.chart.XDDFDataSourcesFactory;
import org.apache.poi.xddf.usermodel.chart.XDDFNumericalDataSource;
import org.apache.poi.xddf.usermodel.chart.XDDFPieChartData;
import org.apache.poi.xssf.usermodel.XSSFChart;
import org.apache.poi.xssf.usermodel.XSSFClientAnchor;
import org.apache.poi.xssf.usermodel.XSSFDrawing;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Pie3DChart {
public static void main(String[] args) throws IOException {
Object[][] data = new Object[][] {
new Object[] {"Country", "Count"},
new Object[] {"India", 13d},
new Object[] {"USA", 5d},
new Object[] {"England", 12d},
new Object[] {"South Africa", 10d}
};
try (XSSFWorkbook wb = new XSSFWorkbook()) {
XSSFSheet sheet = wb.createSheet("piechart");
final int NUM_OF_ROWS = data.length;
final int NUM_OF_COLUMNS = 2;
// create sheet data
Row row;
Cell cell;
for (int rowIndex = 0; rowIndex < NUM_OF_ROWS; rowIndex++) {
row = sheet.createRow((short) rowIndex);
for (int colIndex = 0; colIndex < NUM_OF_COLUMNS; colIndex++) {
cell = row.createCell((short) colIndex);
Object cellValue = data[rowIndex][colIndex];
if (cellValue instanceof String) {
cell.setCellValue((String)cellValue);
} else if (cellValue instanceof Double) {
cell.setCellValue((Double)cellValue);
}
}
}
// create drawing and anchor
XSSFDrawing drawing = sheet.createDrawingPatriarch();
XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 3, 1, 12, 15);
// create chart
XSSFChart chart = drawing.createChart(anchor);
chart.setTitleText("Countries");
chart.setTitleOverlay(false);
XDDFChartLegend legend = chart.getOrAddLegend();
legend.setPosition(LegendPosition.TOP_RIGHT);
XDDFDataSource<String> cat = XDDFDataSourcesFactory.fromStringCellRange(sheet,
new CellRangeAddress(1, NUM_OF_ROWS - 1, 0, 0));
XDDFNumericalDataSource<Double> val = XDDFDataSourcesFactory.fromNumericCellRange(sheet,
new CellRangeAddress(1, NUM_OF_ROWS - 1, 1, 1));
XDDFChartData chartData = chart.createData(ChartTypes.PIE3D, null, null);
chartData.setVaryColors(true);
XDDFChartData.Series series = chartData.addSeries(cat, val);
chart.plot(chartData);
// do not auto delete the title; is necessary for showing title in Calc
if (chart.getCTChart().getAutoTitleDeleted() == null) chart.getCTChart().addNewAutoTitleDeleted();
chart.getCTChart().getAutoTitleDeleted().setVal(false);
// data point colors; is necessary for showing data points in Calc
// some rgb colors to choose
byte[][] colors = new byte[][] {
new byte[] {127,(byte)255, 127},
new byte[] {(byte)200, (byte)200, (byte)200},
new byte[] {(byte)255,(byte)255, 127},
new byte[] {(byte)255, 127, 127},
new byte[] {(byte)255, 0, 0},
new byte[] {0, (byte)255, 0},
new byte[] {0, 0, (byte)255},
new byte[] {80, 80, 80}
};
// set data point colors
int pointCount = series.getCategoryData().getPointCount();
for (int p = 0; p < pointCount; p++) {
chart.getCTChart().getPlotArea().getPie3DChartArray(0).getSerArray(0).addNewDPt().addNewIdx().setVal(p);
chart.getCTChart().getPlotArea().getPie3DChartArray(0).getSerArray(0).getDPtArray(p)
.addNewSpPr().addNewSolidFill().addNewSrgbClr().setVal(colors[p]);
}
// write the output to a file
try (FileOutputStream fileOut = new FileOutputStream("ooxml-pie-chart.xlsx")) {
wb.write(fileOut);
}
}
}
}
这篇关于如何使用Apache poi 4.1.2在Pie 3D Chart中设置自定义颜色的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!