Excel API Library for Java - Sample Browser | Document Solutions | Add a treemap chart
[
フレーム]
src="bundle.js">
This sample demonstrates how to create a treemap chart.
// 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")