// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:B11").setValue(new Object[][]{ {"Complaint", "Count"}, {"Too noisy", 27}, {"Overpriced", 789}, {"Food is tasteless", 65}, {"Food is not fresh", 9}, {"Food is too salty", 15}, {"Not clean", 30}, {"Unfriendly staff", 12}, {"Wait time", 109}, { "No atmosphere", 45}, {"Small portions", 621 } }); worksheet.getRange("A:A").getColumns().autoFit(); //Create a histogram chart. IShape shape = worksheet.getShapes().addChart(ChartType.Histogram, 300, 20, 300, 200); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B11")); //Sets bins type by count. shape.getChart().getChartGroups().get(0).setBinsType(BinsType.BinsTypeBinCount); shape.getChart().getChartGroups().get(0).setBinsCountValue(3); //Set overflow bin value shape.getChart().getChartGroups().get(0).setBinsOverflowEnabled(true); shape.getChart().getChartGroups().get(0).setBinsOverflowValue(500); // Save to an excel file workbook.save("AddHistogramChart.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1:B11").setValue(arrayOf(arrayOf("Complaint", "Count"), arrayOf("Too noisy", 27), arrayOf("Overpriced", 789), arrayOf("Food is tasteless", 65), arrayOf("Food is not fresh", 9), arrayOf("Food is too salty", 15), arrayOf("Not clean", 30), arrayOf("Unfriendly staff", 12), arrayOf("Wait time", 109), arrayOf("No atmosphere", 45), arrayOf("Small portions", 621))) worksheet.getRange("A:A").columns.autoFit() //Create a histogram chart. val shape = worksheet.shapes.addChart(ChartType.Histogram, 300.0, 20.0, 300.0, 200.0) shape.chart.seriesCollection.add(worksheet.getRange("A1:B11")) //Sets bins type by count. shape.chart.chartGroups.get(0).binsType = BinsType.BinsTypeBinCount shape.chart.chartGroups.get(0).binsCountValue = 3 //Set overflow bin value shape.chart.chartGroups.get(0).binsOverflowEnabled = true shape.chart.chartGroups.get(0).binsOverflowValue = 500.0 // Save to an excel file workbook.save("AddHistogramChart.xlsx")