ag-grid-enterprise

What is ag-grid-enterprise?

The ag-grid-enterprise npm package is a powerful data grid component for JavaScript frameworks like Angular, React, and Vue. It provides advanced features for data manipulation, visualization, and interaction, making it suitable for enterprise-level applications.

What are ag-grid-enterprise's main functionalities?

Pivoting

Pivoting allows you to dynamically change the structure of your data, summarizing it in a way that makes it easier to analyze. The code sample demonstrates how to enable pivot mode and define pivot columns.

const gridOptions = {
  columnDefs: [
    { field: 'athlete', pivot: true },
    { field: 'age' },
    { field: 'country' },
    { field: 'year' },
    { field: 'date' },
    { field: 'sport' },
    { field: 'gold' },
    { field: 'silver' },
    { field: 'bronze' },
    { field: 'total' }
  ],
  pivotMode: true,
  rowData: null // set row data here
};

Row Grouping

Row Grouping allows you to group rows based on the values of one or more columns. The code sample shows how to enable row grouping for the 'country' and 'year' columns.

const gridOptions = {
  columnDefs: [
    { field: 'athlete' },
    { field: 'age' },
    { field: 'country', rowGroup: true },
    { field: 'year', rowGroup: true },
    { field: 'date' },
    { field: 'sport' },
    { field: 'gold' },
    { field: 'silver' },
    { field: 'bronze' },
    { field: 'total' }
  ],
  rowData: null // set row data here
};

Aggregation

Aggregation allows you to perform calculations on your data, such as summing up values. The code sample demonstrates how to set up aggregation functions for the 'gold', 'silver', 'bronze', and 'total' columns.

const gridOptions = {
  columnDefs: [
    { field: 'athlete' },
    { field: 'age' },
    { field: 'country' },
    { field: 'year' },
    { field: 'date' },
    { field: 'sport' },
    { field: 'gold', aggFunc: 'sum' },
    { field: 'silver', aggFunc: 'sum' },
    { field: 'bronze', aggFunc: 'sum' },
    { field: 'total', aggFunc: 'sum' }
  ],
  rowData: null // set row data here
};

Excel Export

Excel Export allows you to export your grid data to an Excel file. The code sample shows how to trigger an Excel export when the grid is ready.

const gridOptions = {
  columnDefs: [
    { field: 'athlete' },
    { field: 'age' },
    { field: 'country' },
    { field: 'year' },
    { field: 'date' },
    { field: 'sport' },
    { field: 'gold' },
    { field: 'silver' },
    { field: 'bronze' },
    { field: 'total' }
  ],
  rowData: null, // set row data here
  onGridReady: function(params) {
    params.api.exportDataAsExcel();
  }
};

Other packages similar to ag-grid-enterprise

handsontable

Handsontable is a JavaScript data grid component with a spreadsheet-like interface. It offers features like data validation, sorting, filtering, and CRUD operations. Compared to ag-grid-enterprise, Handsontable has a more Excel-like user experience but may lack some of the advanced enterprise features like pivoting and complex aggregation.

react-table

React Table is a lightweight, fast, and extendable data grid built specifically for React. It provides basic features like sorting, filtering, and pagination. While it is highly customizable and easy to use, it does not offer as many built-in advanced features as ag-grid-enterprise, such as pivoting and Excel export.

slickgrid

SlickGrid is a JavaScript grid/spreadsheet component that offers high performance and a rich set of features like column resizing, reordering, and custom cell formatting. It is highly customizable but requires more effort to set up and configure compared to ag-grid-enterprise.

README

Module	Info
ag-grid-enterprise

AG Grid Enterprise

---

AG Grid is a fully-featured and highly customizable JavaScript data grid. It delivers outstanding performance, has no third-party dependencies and integrates smoothly with all major JavaScript frameworks.

This is not free software, this software is covered by copyright and to use you need a commercial license.

Features

Besides the standard set of features you'd expect from any grid:

• Column Interactions (resize, reorder, and pin columns)
• Pagination
• Sorting
• Row Selection

Here are some of the features that make AG Grid stand out:

• Grouping / Aggregation *

• Accessibility support

• Custom Filtering

• In-place Cell Editing

• Records Lazy Loading *

• Server-Side Records Operations *

• Live Stream Updates

• Hierarchical Data Support & Tree View *

• Customizable Appearance

• Customizable Cell Contents

• State Persistence

• Keyboard Navigation

• Data Export to CSV

• Data Export to Excel *

• Excel-like Pivoting *

• Row Reordering

• Copy / Paste

• Column Spanning

• Pinned Rows

• Full Width Rows

• Integrated Charting

• Sparklines

• The features marked with an asterisk are available in the enterprise version only.

Check out developers documentation for a complete list of features or visit our official docs for tutorials and feature demos.

• Get Started with JavaScript
• Get Started with Angular
• Get Started with React
• Get Started with Vue

Issue Reporting

If you are an Enterprise customer (or are evaluating AG Grid Enterprise) and wish to report a Bug or raise a new Feature Request please do so on our Support Portal.

To Sign Up: Send an email to [e-mail] with your license key

Asking Questions

Look for similar problems on StackOverflow using the ag-grid tag, or refer to our Support Portal. If nothing seems related, post a new message there. Do not use GitHub issues to ask questions.

Contributing

AG Charts is developed by a team of co-located developers in London. If you want to join the team send your application to [e-mail].

License

Please refer to the LICENSE and SUPPORT_AND_MAINTENANCE.