What is ParamQuery?
ParamQuery is an exceptionally lightweight yet powerful JavaScript spreadsheet and grid solution designed for high-performance data management. Despite its minimal file size and memory footprint, it delivers unmatched performance in loading large datasets, making it significantly faster than other JavaScript-based spreadsheets. The tool includes essential spreadsheet features such as autofill, unlimited worksheets, cross-sheet formulas, Excel-style functions, styling, date and number formatting, comments, merged cells, and seamless import/export in Excel (xlsx), CSV, HTML, and PDF formats.
Every worksheet, cell, row, and column is represented as a plain JavaScript object, allowing dynamic manipulation similar to VB scripting in Excel or Apps Script in Google Sheets. After importing an Excel file, users can instantly use it as a spreadsheet, grid, or treegrid, with effortless switching between these components. ParamQuery uniquely blurs the boundaries between grid, treegrid, and spreadsheet modules, offering true interoperability. It supports server-side interaction via RESTful API and can be integrated with various frameworks like Angular, React, Vue.js, and databases such as MySQL and MongoDB.
Features
- Virtual Rendering: Supports unlimited rows and columns with blazing fast performance, tested up to 50 million rows in Pro version
- Excel-like Features: Includes autofill, cross-sheet formulas, number and date formatting, merge cells, and import/export in xlsx, CSV, HTML, and PDF formats
- Framework Integration: Compatible with plain JavaScript, jQuery, Angular, React, Vue.js, and other contemporary frameworks
- Enterprise Features: Offers row grouping, pivot grid, treegrid, column grouping, batch editing, and full keyboard navigation
- Server-side Interaction: Based on RESTful API, usable with Node.js, Python, PHP, ASP.NET, and databases like MySQL and MongoDB
Use Cases
- Managing and visualizing large datasets in web applications
- Creating interactive dashboards with grid and spreadsheet functionalities
- Implementing data editing and validation in enterprise software
- Building financial or analytical tools with pivot and treegrid features
- Developing applications that require Excel import/export capabilities
FAQs
-
What frameworks does ParamQuery support?
ParamQuery supports plain JavaScript, jQuery, Angular, React, Vue.js, Knockout, and other contemporary frameworks, with examples provided for integration. -
What are the key differences between the Free and Pro versions?
The Free version is released under GPL v3 license with basic features, while the Pro version includes advanced functionalities like smooth scrolling, rich copy-paste, Excel formulas, pivot grid, treegrid with lazy loading, and export to PDF, available under Commercial and OEM licenses. -
How does ParamQuery handle large datasets?
ParamQuery uses virtual rendering to support unlimited rows and columns with high performance, with the Pro version tested up to 50 million rows, and includes features like infinite scrolling and auto height of rows. -
Can ParamQuery import and export Excel files?
Yes, ParamQuery supports import from xlsx and CSV files, including data, formatting, pictures, and multiple spreadsheets, and export to Excel (xlsx), CSV, HTML, and PDF formats, with preservation of data types. -
What server-side technologies can be used with ParamQuery?
ParamQuery's server-side interaction is based on RESTful API and can be used with Node.js, Python, PHP, ASP.NET, J2EE, ColdFusion, and databases like SQL Server, MySQL, and MongoDB.
