pqgrid

Data grid inspired by MS Excel, provides sorting, filtering, paging, grouping, nesting, rows and cell selections, frozen rows, frozen columns, Add, delete, update, search, can display HTML, JSON, Array, XML, inline editing, validations, virtual rendering, virtual scrolling, cross browser, cross platform, Themeroller ready with 24 ready to use themes.


Keywords
grid, excel, datagrid, table, ajax, ui, sort, i18n, summary, themeRoller, freeze, group, search, crud, paging
License
GPL-3.0
Install
bower install pqgrid#v2.0.5

Documentation

jQuery grid plugin, supports 100,000+ records.

ParamQuery Grid (for jQuery)

Angularjs Grid (for Angularjs)

Copyright (c) 2012-2016 Paramvir Dhindsa

Released under GPL v3 license

ParamQuery grid is a lightweight jQuery grid plugin inspired by MS Excel and Google spreadsheet.

Angularjs binding is also supported now. More bindings with other MVC/MVVM frameworks like Knockoutjs, Reactjs are coming soon.

  1. Tutorial

  2. API

  3. Demos or Examples

  4. PHP Integration Tutorial

  5. Angularjs bindings

  6. Angularjs demos

Features:


Local, remote and custom sorting for common data formats like Integer, real numbers, Strings, etc.

Local and remote filtering with header filtering row interface.

Paging with local (Browser) or remote (Ajax) data in any format.

Column and row grouping and fixed summary row.

Frozen rows & columns like Excel.

Export to Excel & CSV format.

Nesting of grids and row details.

Virtual Scrolling and Rendering with unlimited rows and columns support.

Inline Editing: Batch editing, row editing, custom editors, multiline editing, validations.

Hide/ show columns, resizable and reorderable columns through drag and drop.

Theme support.

i18n.

Consistent look and functionality across all major browsers IE(8+), Firefox, Chrome, Opera, etc

Display any data source format like HTML, Array, XML, JSON, etc locally or remotely through Ajax.

Can be used with any server side framework e.g. ASP.NET, MVC3, JSP, JSF, PHP, etc.

Many more...