Fork me on GitHub
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.


Jan 24, 2017

ParamQuery Grid features:

Paging

Local

Remote

Filtering

Local

Remote

Header Row Interface

Sorting

Local

Remote

Multiple column

Grouping

Column (unlimited level)

Row (unlimited level)

Fixed summary row at bottom

Virtualization

Unlimited rows

Unlimited columns

Infinite scrolling

Spreadsheet/Excel

Frozen rows

Frozen columns

Full Keyboard navigation

Inline editing

Row editing

Batch editing with commit and rollback

Multiline editing

Custom editors

Validations

Selections

Row selections

Cell selections

Checkbox selections

Multiple selections

Hierarchy

Nested grids

Row details

Export

Csv

Excel

MVC/MVVM

Angularjs bindings http://angularjsgrid.com

Touch support

Swipe

Single & Double tap

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