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
  • Drag and drop to re-order columns, re-group columns and re-group rows
  • Multiple column sorting
  • Unlimited rows & columns with variable 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
 

Thanks to open architecture based on easy to use RESTful API, ParamQuery has been implemented with all sorts of popular server side languages i.e., PHP, ASP, ASP.NET, Java, Python, Cold Fusion, etc. Save time and resources by utilizing ready to use server side implementations in ASP.NET (MVC)/ MSSQL, PHP5/ MySQL and Java (Spring)/ MySQL provided in the demos backed by powerful support system.

Indulge the deserving users with eclectic features of the grid and write single code base that works across all platforms and devices i.e., desktop, mobile phones and tablets thanks to responsive design and touch support provided by ParamQuery for all features out of the box.

Theme Roller ready Bootstrap3 ready Download v4.0.1
Last Release Date: Sept 11, 2017
Dependencies: jQuery >= 1.7, jQueryUI >= 1.11.4
License
Upgrade
Demos
Tutorial
API

ParamQuery grid is a real beauty - awesome functionality and easy to use! I have been using it now for the best part of a year and never had the impression that it is not up to the job. It deals with large tables (100k+) browser side like a charm!

Stephan, Software developer at ANZ

Some of our Enterprise / OEM / Ultimate users: