//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:D6").setValue(new Object[][]{ {null, "S1", "S2", "S3"}, {"Item1", 10, 25, 25}, {"Item2", 51, 36, 27}, {"Item3", 52, 85, 30}, {"Item4", 22, 65, 65}, {"Item5", 23, 69, 69} }); //Add a chart sheet. IWorksheet chartSheet = workbook.getWorksheets().add(SheetType.Chart); //Add the main chart for the chart sheet. IShape mainChart = chartSheet.getShapes().addChart(ChartType.ColumnClustered, 100, 100, 200, 200); mainChart.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6")); //Make the chart sheet the active sheet. chartSheet.activate(); //save to an excel file workbook.save("AddChartSheet.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1:D6").setValue(arrayOf(arrayOf(null, "S1", "S2", "S3"), arrayOf("Item1", 10, 25, 25), arrayOf("Item2", 51, 36, 27), arrayOf("Item3", 52, 85, 30), arrayOf("Item4", 22, 65, 65), arrayOf("Item5", 23, 69, 69))) //Add a chart sheet. val chartSheet = workbook.worksheets.add(SheetType.Chart) //Add the main chart for the chart sheet. val mainChart = chartSheet.shapes.addChart(ChartType.ColumnClustered, 100.0, 100.0, 200.0, 200.0) mainChart.chart.seriesCollection.add(worksheet.getRange("A1:D6")) //Make the chart sheet the active sheet. chartSheet.activate() //save to an excel file workbook.save("AddChartSheet.xlsx")