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.
Inspired by MS Excel and Google spreadsheet, it supports important spreadsheet features like Autofill, 90 common Excel formulas, import from and export to Excel ( xlsx ), merged cells.
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.
|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)|
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|