guicedee/jwebmp-aggrid-enterprise

JWebMP AG Grid Enterprise

AG Grid Enterprise integration for JWebMP with premium data grid features.

Premium Features

• Row Grouping — Group rows by columns
• Aggregation — Sum, avg, min, max, count
• Pivoting — Pivot data dynamically
• Master/Detail — Expandable row details
• Server-Side Row Model — Handle millions of rows
• Excel Export — Export to .xlsx
• Range Selection — Select cell ranges
• Clipboard — Copy/paste operations
• Status Bar — Aggregation status bar
• Charts Integration — Built-in charting

Row Grouping

gridOptions
    .setRowGroupPanelShow("always")
    .setGroupSelectsChildren(true)
    .setColumnDefs(List.of(
        new ColumnDef()
            .setField("country")
            .setRowGroup(true)
            .setHide(true),
        new ColumnDef()
            .setField("sales")
            .setAggFunc("sum")
    ));

Aggregation

new ColumnDef()
    .setField("amount")
    .setAggFunc("sum")  // sum, min, max, avg, count, first, last
    .setEnableValue(true);

Pivoting

gridOptions
    .setPivotMode(true)
    .setColumnDefs(List.of(
        new ColumnDef()
            .setField("country")
            .setPivot(true),
        new ColumnDef()
            .setField("year")
            .setRowGroup(true),
        new ColumnDef()
            .setField("sales")
            .setAggFunc("sum")
    ));

Master/Detail

gridOptions
    .setMasterDetail(true)
    .setDetailCellRendererParams(new DetailCellRendererParams()
        .setDetailGridOptions(detailGridOptions)
        .setGetDetailRowData(callbackFunction));

Server-Side Row Model

gridOptions
    .setRowModelType("serverSide")
    .setServerSideStoreType("full")  // full, partial
    .setCacheBlockSize(100)
    .setMaxBlocksInCache(10);

Excel Export

gridOptions.exportToExcel(new ExcelExportParams()
    .setFileName("data.xlsx")
    .setSheetName("Sheet1")
    .setAuthor("JWebMP")
    .setColumnWidth(100));

Range Selection

gridOptions
    .setEnableRangeSelection(true)
    .setEnableRangeHandle(true)
    .setEnableFillHandle(true);

Status Bar

gridOptions.setStatusBar(new StatusBarConfig()
    .setStatusPanels(List.of(
        new StatusPanelDef()
            .setStatusPanel("agTotalAndFilteredRowCountComponent"),
        new StatusPanelDef()
            .setStatusPanel("agAggregationComponent")
    )));

Installation

<dependency>
  <groupId>com.jwebmp.plugins</groupId>
  <artifactId>aggrid-enterprise</artifactId>
</dependency>

Note: Requires valid AG Grid Enterprise license.

License Configuration

GridOptions.setLicenseKey("your-license-key");

References

• Module: com.jwebmp.plugins.aggridenterprise
• AG Grid Enterprise: 33.x
• Java: 25+
• License: Apache 2.0 (code), AG Grid Enterprise license required
• AG Grid Enterprise