[]
TreeMap是一种图表类型,用于将分层数据显示为一组嵌套矩形。树状图用于以树状结构表示层次结构数据。借助矩形来描绘组织为分支和子分支的数据。使用树形图,您可以轻松地将海量数据挖掘到无限数量的级别。
请参考以下代码以添加树形图:
private static void TreemapChart() {
// Initialize workbook
Workbook workbook = new Workbook();
// Fetch default worksheet
IWorksheet worksheet = workbook.getWorksheets().get(0);
// Prepare data for chart
worksheet.getRange("A1:D16")
.setValue(new Object[][] {
{ "Region", "Subregion", "Country", "Population" },
{ "Asia", "Southern", "India", 1354051854 },
{ null, null, "Pakistan", 200813818 },
{ null, null, "Bangladesh", 166368149 },
{ null, null, "Others", 170220300 },
{ null, "Eastern", "China", 1415045928 },
{ null, null, "Japan", 127185332 },
{ null, null, "Others", 111652273 },
{ null, "South-Eastern", null, 655636576 },
{ null, "Western", null, 272298399 },
{ null, "Central", null, 71860465 },
{ "Africa", "Eastern", null, 433643132 },
{ null, "Western", null, 381980688 },
{ null, "Northern", null, 237784677 },
{ null, "Others", null, 234512021 },
{ "Europe", null, null, 742648010 },
{ "Others", null, null, 1057117703 } });
worksheet.getRange("A:D").getColumns().autoFit();
// Add Treemap Chart
IShape treeMapChartShape = worksheet.getShapes().addChart(ChartType.Treemap, 250, 20, 360, 330);
// Adding series to SeriesCollection
treeMapChartShape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D16"), RowCol.Columns, true,
true);
// Configure Chart Title
treeMapChartShape.getChart().getChartTitle().setText("World Population");
// Saving workbook to Xlsx
workbook.save("33-TreemapChart.xlsx", SaveFileFormat.Xlsx);