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