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.
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.
By clicking on the header menu item with the name of a column you can make the corresponding grid column either visible or invisible.
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.
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.
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.
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.
You can place text in Webix Pro datagrid not only horizontally, but also vertically. Such a text arrangement will help you save space and place more info in your DataTable.
You can create a grid with two frozen areas on the left and right sides with scrollable columns in between.
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.