dhtmlxGrid is an Ajax-enabled JavaScript grid control with cutting-edge functionality, powerful data binding, and excellent performance with large datasets. The component is easy-to-use and provides great flexibility due to its rich client-side API. dhtmlxGrid supports different datasources (XML, JSON, CSV, JavaScript array, and HTML table), and can be also loaded from custom XML format if needed.

The grid component lets you easily implement nice-looking DHTML tables (managed through CSS or predefined skins) with rich in-cell editing and built-in filtering, searching, and grouping capabilities. With numerous event handlers, you can add necessary interactivity to your grid-based interfaces. Smart Rendering and paging support allow this JavaScript datagrid to work effectively even with huge datasets.

Export to

PDF

Excel

Themes:

DHX Sky Blue

DHX Blue

Modern

Gray

Double-click or [F2] on cell to edit. Use [Tab] to navigate through cells, [Up/Down] - to navigate through rows.
Select multiple rows using [Shift/Ctrl].
Press left mouse button and drag the pointer to create block selection. Copy block to clipboard (if clipboard operations allowed) with Ctrl+C and paste to another program (MS Excel, text editor, etc.).
To filter the Price column, use "<X" to filter values less than X, or ">X" to filter values greater than X. Use "X..Y" to filter range between X and Y.

This video demonstrates the following features available in dhtmlxGrid PRO: dynamic footer, grouping capabilities, search and filter functionality.

You can also watch another video tutorial about how to load large amount of data into the grid, add filters, server-side sorting, and data update capabilities.

Being a 100% client-side JavaScript solution, dhtmlxGrid can be integrated with any server-side technology (PHP, Java, Ruby-on-Rails, .NET, ColdFusion, and others). The dhtmlxConnector library, together with Ajax support, provides the ability to save and update grid data on the server automatically in real time without page reload.

dhtmlxGrid supports the powerful features necessary for web-based spreadsheets, such as merged cells, split mode, the ability to move grid columns (with drag-and-drop or script methods) and copy data to a clipboard (in CSV format). The extensible architecture of our Ajax datagrid allows you to use custom external components as cell editors (on a per cell basis), providing the ability to greatly enrich grid functionality.

As part of the DHTMLX library, dhtmlxGrid can be easily integrated with other components within a common application interface using dhtmlxLayout. With a new skin, introduced in version 2.5, all DHTMLX components took on a slick and clean look which can perfectly match the design of any modern website or application.

Features

• Cross-browser compatibility
• Full control with JavaScript API
• Ajax support
• Simple JavaScript or XML configuration
• Integration with HTML forms
• Built-in filtering, searching, grouping capabilities
• Auto-calculated values in footer/header
• In-line editing
• Ready-to-use solutions for large datasets: paging, dynamic loading, Smart Rendering
• Serialization to XML/CSV
• Loading from XML/CSV
• Frozen columns
• Clipboard support
• Easy client-to-server communication (with dhtmlxConnector, available for PHP, Java, .NET, ColdFusion)
• Support for subgrids within grid
• Resizable/movable columns
• Drag-and-drop rows/columns within the grid
• Drag-and-drop in/from dhtmlxTree PRO Edition
• Ability to create any editor or cell formatting (using eXcell - eXtended cell object)
• Combobox, calendar, and more predefined eXcells
• Math formulas for cells
• Different keyboard mappings
• Easy styling with CSS or predefined skins
• Invisible data blocks for rows/entire grid (userdata)
• Client-side sorting (string, integer, date, custom)
• Server-side sorting ready
• Wide range of event handlers
• Detailed documentation
* - some functionality available in PRO Edition only

Editions

dhtmlxGrid is available in Standard and Professional Editions (see feature comparison table).

Licenses

Open Source - GPL - Allows the use of dhtmlxGrid Standard in GPL projects for free.

Commercial License - Includes dhtmlxGrid Professional Edition and allows you to use it in one project (application) with an unlimited number of copies. With this license, you receive 1 month of technical support (or 5 support requests within 12 months) and one major update. This license costs $199.

Enterprise License - Includes dhtmlxGrid Professional Edition and allows you to use it in an unlimited number of projects on the condition that all of them are developed by one company. Free support/upgrades are provided for the first 12 months. This license costs $449.