Spreadsheet features:

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:

  1. Support for around 90 commonly used Excel formulas complemented by intellisense.
  2. 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.
  3. Basic cell level formatting like text-align, wrap, background color, font-color, font size, font style, etc.
  4. Merged cells
  5. 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.
  6. Import of csv file support added in v7.4.0.
  7. 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.
  8. 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

Color picker

This example uses pqColor picker. However you can integrate HTML5 or any color picker of your choice with pqgrid spreadsheet.