EditableGrid is an open source JavaScript library aimed at turning tables into fully editable components. Its API is focused on simplicity : only a few lines of code are necessary to get your first editable grid up and running.
Originally, EditableGrid was a component developed for Hiflow Suite. Thereafter, we decided to factorize it into an external library. We think that this tool can be useful in other web projects. This is why we chose to publish it under the MIT Licence. We use Open Source software everyday and we wanted to offer our small contribution. If you use EditableGrid, feel free to tell us. The best motivation is to know that our work is used and appreciated.
Features
Multiple formats
Load data from XML, JSON (URL or string) or attach to an existing HTML table.
Sort
Sort columns accordingly to their types, by clicking on the column header
Filter
Filtering of the grid.
Pagination
Full client-side or server-side pagination
Typed Columns
Each column is typed (string, integer, double, boolean, url, email, date).
Cell Editor
Edit cells with a suitable editor, according to the column type (eg. checkbox for boolean).
Enum Values
Possibility to declare a list of possible values for the cells of a column (statically or in Javascript).
Number Formatting
Easily customized formatting for numeric columns (unit, precision, thousands separator, decimal point, NaN symbol)
Cell validators
Built-in validators for columns of type integer, double, url, email and date
Local Storage
Grid state saved and restored using localStorage
And more...
- Possibility to plug your own cell renderers, editors and validators
- PHP binding: build your grid in PHP and let it generate the XML file
- Insert and remove rows
- Support for option groups in columns with enumerated values
- Open Flash Chart integration: render bar and pie charts from the grid data (follows when editing, sorting and filtering)
- Stand-alone: no dependencies are needed
- Automatic support for jQuery UI date pickers if jQuery UI is detected
- Support for jQuery autocomplete inputs (through an extension)
- Callbacks for all events: load, edition, sorting, etc.