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.
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.
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.
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.
This example uses pqColor picker. However you can
integrate HTML5 or any color picker of your choice with pqgrid spreadsheet.