ParamQuery grid is the best open source jQuery grid plugin with enterprise features like row grouping, pivot, treegrid, column grouping, nesting, batch editing, export to multiple formats, selections, full keyboard navigation in addition to the basic features like sorting, filtering, paging, inline editing, validations, etc.
It's the only grid to truly support unlimited rows and columns with blazing fast performance.
Server side interaction is based on simple RESTful API and it can be implemented in any server side language i.e., Nodejs, Python, PHP, ASP.NET, J2EE, Cold fusion, etc while data can be served from and persisted in any kind of storge like Sql server, MySQL, MongoDB etc.
Free version of grid is released under GPL v3 license while Pro version is released under Commercial and OEM license. Please scroll down for feature wise comparison between free and Pro versions.
It supports important spreadsheet features like Autofill, 90 common Excel formulas, styles ( colors, borders, italic, bold, underline, font-family, font-size, etc ), dates and number formatting, comments, import from and export to Excel xlsx, csv format, merged cells, etc.
Even more, after opening a xlsx spreadsheet, it can be used as a simple grid or a treegrid and vice versa. Most features of spreadsheet and other modules are interoperable which is unique to ParamQuery thus abolishing the boundaries between grid, treegrid and spreadsheet applications.
|Features||Free version||Pro version||Comments|
|Virtual rendering( unlimited rows & columns even in IE )||yes||yes||PQ grid is the only one to support unlimited rows and columns.|
|Infinite scrolling||view||view, view|
|Smooth scrolling in virtual rendering||-||yes|
|Auto height of rows in virtual rendering||yes||yes||No other grid except pqgrid and handsontable supports this feature.|
|Conditional styles of rows/cells||yes||yes|
|Touch & swipe support||yes||yes (native)|
|RTL ( Right to Left ) layout||view|
Drag and drop
|Between grid and other components||view|
|Reorder rows in grid with row grouping||view|
|Between grids with row grouping||view|
|Reorder rows in treegrid||view|
|Frozen rows, columns and summary rows||yes||yes|
|Auto fill, drag to fill||-||view||Very few grids support these premium features.|
|Merge cells||-||view, view|
|Import from xlsx of data, formatting, pictures, multiple spreadsheets, etc||-||view|
|Import from csv||-||view|
|Cell referencing & Excel formulas||-||view|
|Export to Excel||yes (xml format)||yes (xlsx format)|
|Export of data, merge cells, Excel formulas, number and dates formatting, grouped rows & columns, pictures to multiple spreadsheets||-||yes|
|Combined export of multiple grids to one workbook||-||view|
|Export of static and conditional styles||-||view|
|Preservation of data type of cells (dates, numbers) between Excel export and import||-||yes|
|Export to csv||yes||yes|
|Export to html||yes|
|Pivot grid with drag n drop toolPanel||-||view|
|Tree grid with aggregates, cascade checkboxes, custom icons, etc||-||view|
|Tree grid with lazy loading||-||view|
|Nested grids (upto any level)||yes||yes|
|Cell||yes||yes (Range based API)|
|History, undo & redo||yes||yes|
|Batch editing with commit and rollback||yes||yes|
|License||GPL v3||Evaluation, Commercial & OEM|
|Download url ( opens a new window )||[ Download ]||[ Download ]|