Spreadsheet features:

  1. It supports 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.


Color picker

This example uses Spectrum color picker: http://bgrins.github.io/spectrum/ However you can integrate any color picker of your choice with pqgrid spreadsheet.