[]
        
(Showing Draft Content)

树状图

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);