怎么用代码生成Excel的组合图？

Question

怎么用代码生成Excel的组合图？

我想通过代码在excel里面生成一个组合图，这个怎么搞

语言是JAVA

Answer 1

可以通过GcExcel来实现组合图，GcExcel支持各种Excel图表，具体可以参考：
图表类型 - GcExcel 中文文档Java版 | 服务端高性能表格组件 - 葡萄城
生成组合图的代码如下：

public void ComboCharts(){
    // 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:B13").setValue(new Object[][]{
            {"Blue Column", "Red Line"},
            {75, 20},
            {149, 50},
            {105, 30},
            {55, 80},
            {121, 40},
            {76, 110},
            {128, 50},
            {114, 140},
            {75, 60},
            {105, 170},
            {145, 70},
            {110, 100}
    });
    shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B13"), RowCol.Columns);
    shape.getChart().getChartTitle().setText("Combination Chart");
//change series type
    ISeries series2 = shape.getChart().getSeriesCollection().get(1);
    series2.setChartType(ChartType.LineMarkers);

// Save to an excel file
    workbook.save("output/CombinationChart1.xlsx");
}