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 can also be used as plain javascript grid or even with contemporary frameworks like Angular, React, Vuejs, etc. Examples are provided for the usage of ParamQuery with aforementioned frameworks.
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.
ParamQuery is a lightweight yet advanced web based javascript control for desktop, laptop or mobile phones
It supports important spreadsheet features like Autofill, unlimited worksheeets, cross worksheet calculations, most of the commonly used Excel formulas, styles, dates and number formatting, comments, import from and export to Excel xlsx, csv format, merged cells, etc.
Every cell, row and column in spreadsheet corresponds to plain javascript object. In fact whole spreadsheet is designed around a simple JSON model which is fully scriptable providing full flexibility and interactivity at your coding fingertips. Consider this similar to VB scripting for MS Excel and Apps scripting for Google spreadsheets.
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.
This example is based on mock data for demonstration purpose only.
Feature comparison between Free and Pro versions
| Features | Free version | Pro version | Comments |
|---|---|---|---|
Framework support |
|||
| Angularjs | yes | yes | |
| Angular(2+) | yes | yes | |
| jQuery | yes | yes | |
| Knockout | yes | yes | |
| React | yes | yes | |
| Vue | yes | yes | |
Rendering |
|||
| 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) | |
| Context menu | view | ||
| RTL ( Right to Left ) layout | view | ||
Drag and drop |
|||
| Reorder rows | view | ||
| Between grids | view | ||
| 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 | ||
| Between treegrids | view | ||
Excel |
|||
| Frozen rows, columns and summary rows | yes | yes | |
| Keyboard navigation | yes | yes | |
| Copy paste | yes | yes | |
| Auto fill, drag to fill | view | view | Very few grids support these premium features. |
| Merge cells | view, view | view, view | |
| Standalone javascript workbook (useful to export / import even third party components) | - | view | |
| Import from xlsx of data, formatting, pictures, multiple spreadsheets, etc | - | view | |
| Import from csv | - | view | |
| Cell referencing & Excel formulas | - | view | |
Export |
|||
| Export to Excel | yes (xlsx 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 | yes | |
Pivot gid |
|||
| Pivot grid with drag n drop toolPanel | - | view | |
Tree gid |
|||
| Tree grid with aggregates, cascade checkboxes, custom icons, etc | - | view | |
| Tree grid with lazy loading | - | view | |
Hierarchy |
|||
| Row details | yes | yes | |
| Nested grids (upto any level) | yes | yes | |
Row grouping |
|||
| unlimited columns | yes | yes | |
| OLAP mode | - | yes | |
| Grouping toolbar | - | yes | |
Column grouping |
|||
| unlimited levels | yes | yes | |
| Collapsed columns | - | yes | |
Paging |
|||
| Local | yes | yes | |
| Remote | yes | yes | |
Sorting |
|||
| Local | yes | yes | |
| Remote | yes | yes | |
Filtering |
|||
| Local | yes | yes | |
| Remote | yes | yes | |
Selections |
|||
| Row | yes | yes | |
| Cell | yes | yes (Range based API) | |
| Checkbox selections | yes | yes | |
Inline editing |
|||
| Row editing | yes | yes | |
| History, undo & redo | yes | yes | |
| Batch editing with commit and rollback | yes | yes | |
| Validations | yes | yes | |
| Conditional editability | yes | yes | |
Licensing |
|||
| License | GPL v3 | Evaluation, Commercial & OEM | |
Download |
|||
| Download url ( opens a new window ) | [ Download ] | [ Download ] | |
Few of pqgrid premium users:
