ParamQuery grid is the fastest 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., PHP, ASP.NET, J2EE, Cold fusion, etc.
It's free to use in any commercial or open source project under GPL v3 license. Hit like or donate star to github repo to support the grid.
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 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, grid, treegrid are interoperable which is unique to ParamQuery thus demolishing the boundaries between grid 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||-||view|
|Cell referencing & Excel formulas||-||view|
|Export to Excel||xml format||xlsx format|
|Export of merge cells, Excel formulas, number and dates formatting, grouped rows & columns||-||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|