// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:D16").setValue(new Object[][]{ {"Quarter", "Month", "Week", "Output"}, {"1st", "Jan", null, 3.5}, {null, "Feb", "Week1", 1.2}, {null, null, "Week2", 0.8}, {null, null, "Week3", 0.6}, {null, null, "Week4", 0.5}, {null, "Mar", null, 1.7 }, {"2st", "Apr", null, 1.1}, {null, "May", null, 0.8}, {null, "Jun", null, 0.3}, {"3st", "July", null, 0.7}, {null, "Aug", null, 0.6}, {null, "Sept", null, 0.1}, {"4st", "Oct", null, 0.5}, {null, "Nov", null, 0.4}, {null, "Dec", null, 0.3}, }); //Create a treemap chart. IShape shape = worksheet.getShapes().addChart(ChartType.Treemap, 300, 20, 300, 200); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D16")); //Set the parent data labels are displayed as banners. shape.getChart().getSeriesCollection().get(0).setParentDataLabelOption(ParentDataLabelOptions.Banner); //Modify chart title text. shape.getChart().getChartTitle().setText("Annual Report"); // Save to an excel file workbook.save("AddTreeMapChart.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1:D16").setValue(arrayOf(arrayOf("Quarter", "Month", "Week", "Output"), arrayOf("1st", "Jan", null, 3.5), arrayOf(null, "Feb", "Week1", 1.2), arrayOf(null, null, "Week2", 0.8), arrayOf(null, null, "Week3", 0.6), arrayOf(null, null, "Week4", 0.5), arrayOf(null, "Mar", null, 1.7), arrayOf("2st", "Apr", null, 1.1), arrayOf(null, "May", null, 0.8), arrayOf(null, "Jun", null, 0.3), arrayOf("3st", "July", null, 0.7), arrayOf(null, "Aug", null, 0.6), arrayOf(null, "Sept", null, 0.1), arrayOf("4st", "Oct", null, 0.5), arrayOf(null, "Nov", null, 0.4), arrayOf(null, "Dec", null, 0.3))) //Create a treemap chart. val shape = worksheet.shapes.addChart(ChartType.Treemap, 300.0, 20.0, 300.0, 200.0) shape.chart.seriesCollection.add(worksheet.getRange("A1:D16")) //Set the parent data labels are displayed as banners. shape.chart.seriesCollection.get(0).parentDataLabelOption = ParentDataLabelOptions.Banner; //Modify chart title text. shape.chart.chartTitle.setText("Annual Report") // Save to an excel file workbook.save("AddTreeMapChart.xlsx")