使用AG-Grid的行分组功能和数据聚合功能来处理大量数据。代码示例如下:
// 行分组 gridOptions.rowData = [ {province: '东北', city: '哈尔滨', population: 3800000}, {province: '东北', city: '鞍山', population: 3400000}, {province: '东北', city: '吉林', population: 2800000}, {province: '华东', city: '上海', population: 24240000}, {province: '华东', city: '杭州', population: 7245000}, {province: '华东', city: '南京', population: 6561000}, // more data... ];
gridOptions.columnDefs = [ {headerName: '省份', field: 'province', rowGroup: true}, {headerName: '城市', field: 'city'}, {headerName: '人口数', field: 'population', aggFunc: 'sum'} ];
// 数据聚合 gridOptions.columnDefs = [ {headerName: '日期', field: 'date'}, {headerName: '销售额', field: 'sales', aggFunc: 'sum'}, {headerName: '利润', field: 'profit', aggFunc: 'sum'} ];
gridOptions.rowData = [ {date: '2020-01-01', sales: 10000, profit: 5000}, {date: '2020-01-02', sales: 20000, profit: 10000}, {date: '2020-01-03', sales: 30000, profit: 15000}, // more data... ];