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 donate star to github repo to support the grid.
ParamQuery Grid Pro is the commercial grade version of ParamQuery Grid and has been a tool of choice for professional enterprise applications for desktop, mobile and touch devices. It offers the finest coveted features of a powerful jQuery grid and spreadsheet and is built upon the principles of performance, superior UX and open standards. The following features of Pro are supplementary to the basic functionality of ParamQuery Grid.
Pro Features:
- Import from Excel (xlsx)
- Export to Excel (xlsx), Csv, Html, Json
- Excel formula support
- Copy paste to and from clipboard
- Range / Row grouping with aggregates
- Merged cells with unlimited rowspan and colspan
- Tree grid with aggregates
- Pivot grid with drag n drop toolPanel GUINew, Jan 2018
- Multiple column sorting
- Unlimited rows & columns with auto and fixed row heights
- Frozen rows and columns like Excel
- Hidden rows and columns
- Filter API and header filter row
- Printing
- Checkbox columns and selections
- Cell validations and warnings
- Row editing, batch editing and auto save
- Atomic transactions (commit and rollback)
- Nesting of grids/sub grids
- Detail of rows
- Swipe support for desktop and touch devices
- Fluid and responsive layouts
- Bootstrap and custom themes
- Server side examples in ASP.NET (MVC)/ MSSQL
- Server side examples in PHP5/ MySQL
- Server side examples in Java/ MySQL
Basic Features:
- Local and remote paging, sorting and filtering
- Multiple row and cell selections with full customization
- Hiding or showing columns
- Resizable columns and grid
- Columns grouping
- Summary of rows
- CRUD (Create, read, update, delete)
- Internationalization and localization
- Display any data format like html, array, xml, json, etc sourced locally or remotely
- Virtual and infinite scrolling for rows
- Inline editing of cells
- Custom cell rendering & editing
- Theme roller ready with 24 ready to use themes
- Full keyboard navigation
- Consistent look and functionality across all major browsers IE(9+), Firefox, Chrome, Opera, etc
