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 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.

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. Hit like or donate star to github repo to support the grid.

 


 

With release of version 7, ParamQuery can not only open and view Spreadsheets, but it can also edit and save the changes, all web based! at the convenience of your desktop, laptop or your mobile phone. It's lightweight and entirely written in javascript.

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.

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.


Feature comparison between Free and Pro versions

FeaturesFree version Pro versionComments

Framework support

Angularjsyesyes
Angular(2+)-yes
jQueryyesyes
Knockout-yes
React-yes
Vue-yes

Rendering

Virtual rendering( unlimited rows & columns even in IE )yesyes PQ grid is the only one to support unlimited rows and columns.
Infinite scrollingviewview, view
Smooth scrolling in virtual rendering-yes
Auto height of rows in virtual renderingyesyes No other grid except pqgrid and handsontable supports this feature.
Conditional styles of rows/cellsyesyes
Touch & swipe supportyesyes (native)
Context menuview
RTL ( Right to Left ) layoutview

Drag and drop

Reorder rowsview
Between gridsview
Between grid and other componentsview
Reorder rows in grid with row groupingview
Between grids with row groupingview
Reorder rows in treegridview
Between treegridsview

Excel

Frozen rows, columns and summary rowsyesyes
Keyboard navigationyesyes
Copy pasteyesyes
Auto fill, drag to fill-view Very few grids support these premium features.
Merge cells- view, view
Javascript workbook (useful to export / import even third party components)-view
Import from xlsx-view
Cell referencing & Excel formulas-view

Export

Export to Excelyes (xml format)yes (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 csvyesyes
Export to htmlyes

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 detailsyesyes
Nested grids (upto any level)yesyes

Row grouping

unlimited columnsyesyes
OLAP mode-yes
Grouping toolbar-yes

Column grouping

unlimited levelsyesyes
Collapsed columns-yes

Paging

Localyesyes
Remoteyesyes

Sorting

Localyesyes
Remoteyesyes

Filtering

Localyesyes
Remoteyesyes

Selections

Rowyesyes
Cellyesyes (Range based API)
Checkbox selectionsyesyes

Inline editing

Row editingyesyes
History, undo & redoyesyes
Batch editing with commit and rollbackyesyes
Validationsyesyes
Conditional editabilityyesyes

Licensing

LicenseGPL v3Evaluation, Commercial & OEM

Download

Download url ( opens a new window )[ Download ] [ Download ]

Few of pqgrid premium users: