JavaScript SpreadSheet/DataGrid
by Paul Verest
NOTE: This is open-source article you can contribute and extend.
Looking closely
Advice: When started search never, never stop on the first finding, but use it as base for search and comparison. When it is the best it is connected with other solutions more then any.
I started my search from DHTMLX, then googling. When a got several results, I asked friend. Then I went to StackOverflow.com that revealed a bit different picture.
Popular free open-source grids jqGrid, Flexigrid, SlickGrid, DataTables are all dependent on jQuery.
Handsontable
added 2013-08-29.
http://handsontable.com/ https://github.com/warpech/jquery-handsontable 2200 stars Marcin Warpechowski
Live example
Similar projects
I want to stay motivated to keep Handsontable the best possible editable datagrid on the Web. Therefore, I invite you to check out alternative projects. I would love to receive feedback if you would like to import some of their features to Handsontable.
SlickGrid
A friend of mine advised me SlickGrid, that was great help because I could not find it. (Now I added it into Wikipedia, so maybe you have already found this way).
It is just 1 year old project hosted on GitHub, that grew popular (3000+ stars). However it is personal projects and the author seems to be overwhelmed with issues and Pull Requests stream.
SlickGrid seems to focus on performance from the very beginning. 50k+ rows is quite normal.
jqGrid
jQuery Grid 1.0 beta May 5th, 2007 jQuery Grid is my first jQuery plugin…
project home, sources, online examples
jqGrid is oldie, with a lot of online info and maybe some dust. It supports data from XML sources, it is likely has started from XML then added JSON.
jqGrid is foundation for commercial offering Trirand jqSuite http://www.trirand.net.
Flexigrid
Very lean web site http://flexigrid.info/ has examples, and all links. code on GitHub 400 stars
Last code update 4 month ago, seems a bit quiet.
DataTables
DataTables https://datatables.net
In order for DataTables to be able to function correctly, the HTML for the target table must be laid out in a well formed manner with the ‘thead’ and ‘tbody’ sections declared.
sources on GitHub 900 stars
The development went plugin way: Core DataTabled is now stable for a year, while development goes in additiona features.
Other
- Long list of jQuery UI plugings: [jQuery UI Frameworks To Improve Visitors’ User Experience – 25 Plugins] (http://www.designyourway.net/blog/resources/jquery-ui-frameworks-to-improve-visitors-user-experience-25-plugins/)
Googling
What I could find in the very beginning by googling (P.S. was not actually the best way to start):
DHTMLX
http://www.dhtmlx.com/docs/products/dhtmlxSpreadsheet/
dhtmlxSpreadsheet is an open source spreadsheet widget written in JavaScript and PHP that allows you to quickly add an Excel-like, editable data table on a web page. It is also available as a plugin for WP, Joomla, etc.
Free for only GPL-ed projects, then $149 or $449
It exists since 2005 and grow popular, there are some plugins. However it is not fully free, and not pure JavaScript. Though it is the closest approximation to Excel.
jQuery.sheet
http://jqueryplugins.weebly.com/jquerysheet.html by Visopdev http://visop-dev.com/Project+jQuery.sheet
Was not tried yet.
Simple Spreadsheet
http://www.simple-groupware.de/cms/spreadsheet/home
http://en.wikipedia.org/wiki/Simple_Spreadsheet
Simple Spreadsheet (0.5)
Simple Spreadsheet (0.5) - Charts
Simple Spreadsheet (0.4)