ParamQuery grid is the fastest 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 with contemporary frameworks like Angular, React, Vuejs, etc. Examples are provided for the usage of ParamQuery with aforementioned frameworks.

It truly supports 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 incredibly lightweight, boasting a minimal file size and memory footprint, yet offers exceptional loading speed for large spreadsheets. It outperforms any JavaScript-based spreadsheet by loading substantial spreadsheets significantly faster. But don't just take my word for it—verify it yourself!

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, merged cells, import from and export to Excel xlsx, csv, html, pdf format etc.

In ParamQuery, every worksheet, cell, row, and column in a spreadsheet is represented as a plain JavaScript object that can be dynamically manipulated conceptually similar to VB scripting for MS Excel or Apps scripting for Google Spreadsheets.

After importing 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 that helps eliminating the boundaries between grid, treegrid and spreadsheet applications.



Companies using ParamQuery grid:



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 jQuery >= v2.x, jQueryUI >= v1.12.x
Knockout yes yes
React yes yes
Vue yes yes

Browser support

Chrome yes yes
Edge yes yes
Firefox yes yes
IE yes
Safari on Mac yes yes

Rendering

Virtual rendering( unlimited rows & columns ) yes yes Pro version is tested upto 50 milliion rows.
Infinite scrolling view view, view
Scrolling mode in virtual rendering Step scrolling Smooth scrolling
Auto height of rows in virtual rendering yes yes Very few grids support 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
Export to pdf - 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 ]