ParamQuery grid is open source jQuery grid plugin with advanced features like row grouping, column grouping, nesting, batch editing, export to Excel, csv, multiple 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 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 star the github repo to support the grid.
 
RoadMap of ParamQuery

ParamQuery Team is pleased to release version 2.2.0 of jQuery grid (ParamQuery grid) with many tempting features which make it behave like an Excel spreadsheet spreadsheet, most prominent among them are as follows:

1) Copy / paste functionality: At times we have useful data in an Excel spreadsheet, Google spreadsheet or any other spreadsheet program which we want to move to ParamQuery Grid easily. And at other times we wish to do the opposite i.e., we want to move the data from ParamQuery to those applications and sometimes to move the data from one ParamQuery spreadsheet to another ParamQuery spreadsheet! Copy / paste functionality of ParamQuery provides fuss free ability to do it with shortcut keys Ctrl - C, Ctrl - V, thus breaking the barrier between desktop applications and web applications. See it in action.

2) Support for undo / redo: Many a times we wish to revert the changes we recently made in the grid during inline editing, copy / paste or through addRow/updateRow/deleteRow API. It's during these moments that undo comes to the rescue and sends the grid data back in time :)
See it in action.



Please check the change log at github and API for 2.2.0 for more details.


Last Version: 2.3.0, Dec 14, 2017

Feature comparison between Free and Pro versions

FeaturesFree versionPro version

Rendering

Virtual rendering(unlimited rows & columns even in IE)yesyes
Smooth scrolling in virtual rendering-yes
Auto height of rows in virtual renderingyesyes
Conditional styles of rows/cellsyesyes
Touch & swipe supportyesyes (native)

Excel

Frozen rows, columns and summary rowsyesyes
Keyboard navigationyesyes
Copy pasteyesyes
Auto fill, drag to fill-yes
Merge cells-yes
Javascript workbook-yes
Import from xlsx-yes
Excel formulas-yes

Row grouping

unlimited columnsyesyes
OLAP modeyes
Grouping toolbaryes

Pivot gid

Pivot grid with drag n drop toolPanel-yes

Tree gid

Tree grid with aggregates, cascade checkboxes, lazy loading, etc-yes

Hierarchy

Row detailsyesyes
Nested grids (upto any level)yesyes

Column grouping

unlimited levelsyesyes

Export

Export to Excelxml formatxlsx format with merge cells, Excel formulas, basic formatting, simultaneous export of multiple grids in one workbook, etc.
Export to csvyesyes
Export to htmlyes

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

Copyright © 2012 - Paramvir Dhindsa (http://paramquery.com)