This JavaSript table is able to process large amounts of data quickly. Webix grids with a large number of rows and columns are loaded in the blink of an eye. Speed tests showed that DataTable loads 1,000 rows and columns 10 times faster than other grid libraries currently on the market.
The size of the DataTable .js file is half the size of similar grids.
Rowspan and Colspan in DataTable
Thanks to rowspan and colspan functionality you may present even complex data in a readable form just like in HTML tables.
DataTable can load data from XML, JSON and CSV files and also allows you to use your own formats of data. XML and JSON data formats are easily customizable so you can use DataTable with your existing web-services.
Use with jQuery
DataTable provides built-in integration with jQuery framework. You can easily use it as a jQuery plug-in to add a fast and full-featured data grid on any web page. You can also apply jQuery UI skins as needed.
Header Menu in DataTable
By clicking on the header menu item with the name of a column you can make the corresponding grid column either visible or invisible.
Easy Styling with CSS
Advanced Editors in DataTable
Pro DataTable can be used with such complex editors as Multi-select editor, Grid Suggest Editor and DataView Suggest Editor. Multi-select editor allows selecting several options for the edited cell, while Grid editor and DataView editors let you choose the necessary variant from Grid and DataView data, respectively.
Th widget provides the ability to copy/paste data to and from the clipboard so you can easily exchange the grid data with desktop apps like Excel. The clipboard’s support is sustainable in all the latest web browsers, including IE8+, Mozilla Firefox, Opera, Chrome and Safari. In addition, it is possible to export DataTable data to Excel and PDF.
This in-built feature will allow Webix users to expand or collapse multiple columns with just one click. You can define a group of columns yourself and then customize its behaviour.
Saving current DataTable state
This feature makes it possible to save the widget’s state to cookie, local or session storage and then restore it in the next session. The information on all operations performed in the widget will be saved, which will prevent the users of your app from losing some important data.
Ready for Touch Devices
With DataTable advanced filtering functions, you can edit grid’s content either by selecting the appropriate option from a dropdown list (rich-select filter) or even several options at once (multi-select filter), or by entering the necessary date with the help of the in-built calendar.
Fully Resizable and Sortable
Column and row height and width can be changed by dragging the vertical and horizontal borders of the table.
DataTable data can be sorted with a single click on the header of a column.
DataTable supports different modes, allowing you to select data by cell, row, and column. You can also select multiple cells, rows and columns by holding the Ctrl key. You can also click and drag across the cells to select a block of cells.
DataTable is compatible with all modern browsers, including IE8+, the latest versions of Mozilla Firefox, Opera, Chrome and Safari.