Paramquery grid is a JavaScript library that provides a number of spreadsheet features such as support for Excel formulas, cell level formatting, merged cells, importing and exporting of Excel xlsx and CSV files, and programmatically manipulating spreadsheets using a JavaScript API. Here is a summary of the spreadsheet features in Paramquery grid:
Support for around 90 commonly used Excel formulas complemented by intellisense.
Supports absolute and relative references to range of cells e.g., $A$2, $A$1:$D$5, $A:$C, A1:D5, A:A, 6:8, etc in formulas.
Basic cell level formatting like text-align, wrap, background color, font-color, font size, font style, etc.
Merged cells
Import of Excel xlsx files with data, formulas, merged cells, basic styles & formatting, etc.
Xlsx file can be imported from a remote location via url or from HTML5 file input control.
Both ways of importing xlsx files are shown in this example.
Import of csv file support added in v7.4.0.
Programmatically manipulate any spreadsheet with familiar javascript API.
During import and export, Excel workbook can be represented as plain javascript object which opens up lot of manipulation possibilities.
Export of data, formulas, merged cells, basic styles & formatting to Excel xlsx files.
Grid features after import:
After import of a spreadsheet into grid, the data behaves like normal grid data so grid API can be used on it as usual.
colModel
During import, pqgrid generates a new colModel with numeric dataIndx of columns beginning from 0, 1, 2, 3.. and so on.
If the structure of imported Excel spreadsheet is known upfront, then colModel can be predefined and
keepCM: true can be passed to importWb method.
Color picker
This example uses pqColor picker. However you can
integrate HTML5 or any color picker of your choice with pqgrid spreadsheet.