Java 如何生成 Excel 柱状图？-灵析社区
努力的大名Java 如何生成 Excel 柱状图？ 我想通过java代码在一个xlsx文件中生成柱状图，并且导出的时候要与Excel兼容。有什么建议吗？
邦纳娜娜可以通过GcExcel来实现柱状图，GcExcel支持各种Excel图表，具体可以参考：
"图表类型 - GcExcel 中文文档Java版 | 服务端高性能表格组件 - 葡萄城" (https://link.segmentfault.com/?enc=QBBCg6wAyHeXWHrMClPTEw%3D%3D.7CgC6jOYkGuDmlleo6JIk4me4EYvnKtWFZQY5Mn7buYb%2Ba91pYELR%2B9Peri2u67JOU2mZK5NsP2yGn41kGLK%2BPt3G5zS6NIqloRpUWNJ%2FkKa9ms4fh6j6tzQTmk60Gm5cf25OXKa76I74AqWhCODZaSSKcfxI%2BNNlUK%2FQhnQKLc%3D)
生成柱状图的代码如下：
public void CreateColumnChart() {
// Create a new workbook
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().get(0);
IShape shape = worksheet.getShapes().addChart(ChartType.ColumnClustered, 250, 20, 360, 230);
worksheet.getRange("A1:C6").setValue(new Object[][]{
{103, 121, 109},
{56, 94, 115},
{116, 89, 99},
{55, 93, 70},
{114, 114, 83},
{125, 138, 136}
});
shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C6"), RowCol.Columns);
shape.getChart().getChartTitle().setText("Column Clustered Chart");
// Save to an excel file
workbook.save("output/ColumnClusteredChart.xlsx");
}