@syncfusion/ej2-grids

What is @syncfusion/ej2-grids?

@syncfusion/ej2-grids is a comprehensive data grid component for JavaScript applications. It provides a wide range of features for displaying, managing, and interacting with tabular data. The package is part of the Syncfusion Essential JS 2 suite and is designed to be highly customizable and easy to integrate into various frameworks like Angular, React, Vue, and more.

What are @syncfusion/ej2-grids's main functionalities?

Data Binding

This feature allows binding data to the grid from various data sources like JSON, OData, and remote services. The code sample demonstrates how to bind a simple array of JSON objects to the grid and enable paging.

import { Grid, Page } from '@syncfusion/ej2-grids';

let grid = new Grid({
  dataSource: [
    { OrderID: 10248, CustomerID: 'VINET', Freight: 32.38 },
    { OrderID: 10249, CustomerID: 'TOMSP', Freight: 11.61 }
  ],
  allowPaging: true,
  columns: [
    { field: 'OrderID', headerText: 'Order ID', width: 120, textAlign: 'Right' },
    { field: 'CustomerID', headerText: 'Customer ID', width: 150 },
    { field: 'Freight', headerText: 'Freight', width: 120, format: 'C2', textAlign: 'Right' }
  ]
});

grid.appendTo('#Grid');

Sorting

Sorting allows users to order the data in the grid based on column values. The code sample shows how to enable sorting on a grid, allowing users to click on column headers to sort the data.

import { Grid, Sort } from '@syncfusion/ej2-grids';

let grid = new Grid({
  dataSource: [
    { OrderID: 10248, CustomerID: 'VINET', Freight: 32.38 },
    { OrderID: 10249, CustomerID: 'TOMSP', Freight: 11.61 }
  ],
  allowSorting: true,
  columns: [
    { field: 'OrderID', headerText: 'Order ID', width: 120, textAlign: 'Right' },
    { field: 'CustomerID', headerText: 'Customer ID', width: 150 },
    { field: 'Freight', headerText: 'Freight', width: 120, format: 'C2', textAlign: 'Right' }
  ]
});

grid.appendTo('#Grid');

Filtering

Filtering allows users to view a subset of data based on specific criteria. The code sample demonstrates enabling filtering on a grid, allowing users to filter data by entering criteria in the column headers.

import { Grid, Filter } from '@syncfusion/ej2-grids';

let grid = new Grid({
  dataSource: [
    { OrderID: 10248, CustomerID: 'VINET', Freight: 32.38 },
    { OrderID: 10249, CustomerID: 'TOMSP', Freight: 11.61 }
  ],
  allowFiltering: true,
  columns: [
    { field: 'OrderID', headerText: 'Order ID', width: 120, textAlign: 'Right' },
    { field: 'CustomerID', headerText: 'Customer ID', width: 150 },
    { field: 'Freight', headerText: 'Freight', width: 120, format: 'C2', textAlign: 'Right' }
  ]
});

grid.appendTo('#Grid');

Other packages similar to @syncfusion/ej2-grids

ag-grid

AG Grid is a feature-rich data grid supporting major JavaScript frameworks. It offers similar functionalities to @syncfusion/ej2-grids, such as data binding, sorting, filtering, and more. AG Grid is known for its high performance and extensive customization options.

react-table

React Table is a lightweight, fast, and extendable data grid built for React applications. It provides basic functionalities like sorting and filtering but is less feature-rich compared to @syncfusion/ej2-grids. It focuses on simplicity and flexibility, allowing developers to build custom table components.

handsontable

Handsontable is a JavaScript data grid component with Excel-like features. It offers functionalities such as data binding, sorting, and filtering, similar to @syncfusion/ej2-grids. Handsontable is particularly known for its spreadsheet-like interface and ease of use.

README

ej2-grids

The Grid component is used to display and manipulate tabular data with configuration options to control the way the data is presented and manipulated. It will pull data from a data source, such as array of JSON objects, OData web services, or DataManager binding data fields to columns. Also displaying a column header to identify the field with support for grouped records.

This is a commercial product and requires a paid license for possession or use. Syncfusion’s licensed software, including this component, is subject to the terms and conditions of Syncfusion's EULA (https://www.syncfusion.com/eula/es/). To acquire a license, you can purchase one at https://www.syncfusion.com/sales/products or start a free 30-day trial here (https://www.syncfusion.com/account/manage-trials/start-trials).

A free community license (https://www.syncfusion.com/products/communitylicense) is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue and five or fewer developers.

Setup

To install Grid and its dependent packages, use the following command.

npm install @syncfusion/ej2-grids

Resources

• Getting Started
• View Online Demos
• Product Page

Supported Frameworks

Grid component is also offered in following list of frameworks.

1. Angular
2. React
3. VueJS
4. ASP.NET Core
5. ASP.NET MVC
6. JavaScript (ES5)

Showcase samples

• Expanse Tracker (Source, Live Demo)
• Loan Calculator (Source, Live Demo)

Key Features

• Data sources - Bind the Grid component with an array of JSON objects or DataManager.
• Sorting and grouping - Supports n levels of sorting and grouping.
• Filtering - Offers filter UI such as filter bar, menu, excel and checkbox at each column to filter data.
• Paging - Provides the option to easily switch between pages using the pager bar.
• Editing - provides the options for create, read, update, and delete operations.
• Columns - The column definitions are used as the dataSource schema in the Grid. This plays a vital role in rendering column values in the required format.
  • Reordering - Allows you to drag any column and drop it at any position in the Grid’s column header row, allowing columns to be repositioned.
  • Column Chooser - The column chooser provides a list of column names paired with check boxes that allow the visibility to be toggled on the fly.
  • Resizing - Resizing allows changing column width on the fly by simply dragging the right corner of the column header.
  • Freeze - Columns and rows can be frozen to allow scrolling and comparing cell values.
  • Cell Spanning - Grid cells can be spanned based on the preferred criteria.
  • Foreign data source - This provides the option to show values from external or lookup data sources in a column based on foreign key/value mapping.
  • Cell Styling - Grid cell styles can be customized either by using CSS or programmatically.
• Selection - Rows or cells can be selected in the grid. One or more rows or cells can also be selected by holding Ctrl or Command, or programmatically.
• Templates - Templates can be used to create custom user experiences in the grid.
• Aggregation - Provides the option to easily visualized the Aggregates for column values.
• Context menu -The context menu provides a list of actions to be performed in the grid. It appears when a cell, header, or the pager is right-clicked.
• Clipboard - Selected rows and cells can be copied from the grid.
• Export - Provides the options to Export the grid data to Excel, PDF, and CSV formats.
• RTL support - Provides a full-fledged right-to-left mode which aligns content in the Grid control from right to left.
• Localization - Provides inherent support to localize the UI.

Support

Product support is available for through following mediums.

• Creating incident in Syncfusion Direct-trac support system or Community forum.
• New GitHub issue.
• Ask your query in Stack Overflow with tag syncfusion, ej2.

License

Check the license detail here.

Changelog

Check the changelog here

© Copyright 2019 Syncfusion, Inc. All Rights Reserved. The Syncfusion Essential Studio license and copyright applies to this distribution.