Home

Company
  Technologies
  Team
  Workflow
 
Services
  Virtual Office
  Fixed Bid
  Portfolio
 
Products
  dhtmlxTree
  dhtmlxGrid
  dhtmlxTreeGrid
  dhtmlxTabbar
  dhtmlxCombo
  dhtmlxVault
  dhtmlxToolbar
  dhtmlxMenu
  AWTX TreeTable
  AWTX JTree
 
F.A.Q.
Download
Contact us
dhtmlxGrid - editable DHTML AJAX grid with rich Javascript API

dhtmlxGrid is a Ajax-enabled JavaScript grid control that provides professional solution for representing and editing tabular data on the web. Carefully designed, with powerful script API, this editable DHTML grid is easy configurable with XML or js methods and shows convincing results working with large amounts of data.

dhtmlxGrid allows easy implementation of nice looking (managed through css or predefined skins) DHTML tables with rich in-cell editing, fixed multiline headers/footers, resizable, sortable and draggable columns. Numerous event handlers let you add necessary interactivity to grid-based interfaces. Smart Rendering technology and built-in paginal output allow this data grid to work effectively with huge datasets.

Double-click or [F2] on cell to edit. [Tab] to navigate through cells, [Up/Down] - to navigate through rows
Select multiple rows using [Shift/Ctrl]
Press left mouse button and drag the pointer to create block selection. Copy block to clipboard (if clipboard operations allowed) with Ctrl+C and paste to another program (MS Excel, Text Editor etc.).

Being 100% client-side solution and loading data dynamically through Ajax callbacks, dhtmlxGrid can be integrated with any server side technology providing the possibility to automatically save and update data in database in real time without page reload.

Simple and comfortable grid interface supplemented with ability of keyboard navigation allows users to enter and modify tabular data intuitively. Extensible architecture of the grid allows you to use custom external component as cell editor, providing great opportunity to enrich grid functionality. For greater flexibility cell editors can be applied on per cell basis.

dhtmlxGrid supports merged cells, frozen columns and provides the ability to easily move grid columns (using drag-n-drop or script methods) and copy data to clipboard (in CSV format) with further pasting to MS Excel or any other application (try this right now in above live demo).

dhtmlxGrid v.1.4 is available since July 12, 2007
(last build from August 13, 2007).

Main new features include:

  • New eXcells (password, new calendar etc.)
  • New event handlers for better control over grid
  • Extended updateFromXML capabilities
  • Extended list of functionlity available in split mode
  • Serialization available in Smart Rendering mode (static)
  • Fixed known issues and optimized existing functionlity. See complete list here



  • Supported Browsers:

  • IE 5.x and above
  • Mozilla 1.4 and above
  • FireFox 0.9 and above
  • Safari 2.0 and above (1.3 with some limitations)

  • Features:*

  • Full control with JavaScript API
  • Simple JavaScript configuration
  • Integration with HTML Form
  • Async mode loading support (AJAX)
  • Loading/Configuration from XML (file or string)
  • Ability to load big datasets (Smart rendering/paging)
  • Easy styling with CSS or predefined skins
  • Serialization to XML/SCV
  • Working with clipboard
  • Automatized communication with server data source (dhtmlxDataProcessor)
  • Drag-and-drop rows/columns within grid
  • Drag-and-drop in/from dhtmlxTree Pro
  • Selectbox, combobox,checkbox, calendar and more eXcells
  • Math Formulas for cells
  • Ability to create any editor or cell formating
         (using eXcell - eXtended cell object)
  • Invisible data blocks for rows/entire grid (userdata)
  • Resizable/movable columns
  • Client-side sorting (string, integer, date, custom)
  • Wide range of event handlers
  • Detailed documentation

  • * - some functionlity available in professional edition only

    Editions

  • Standard - available for free download (GNU GPL).
  • Professional - contains additional features (with examples) which are not presented in standard edition. Available under Commercial and Enterprise licenses. Contact us to buy.
  • Licensing

  • Open Source - GPL
  • In order to get support or use any edition of dhtmlxGrid in non-GPL project you can purchase Commercial License ($149) or Enterprise License. Please, contact us to buy.
  • Download:

  • v.1.4 Standard Edition (build 70813)
  • v.1.4 Professional Edition Contact us


  • Sample. Using Grid with PHP/MySQL
  • Sample. Using Grid with ASP/MSAccess
  • Sample. Using Grid with JSP/MySQL
  • Sample. Using Grid with ASP.Net
  • Documentation:

  • API Functions and Usage Guide
  • Knowledge Base Light/Extended
  • Examples:

  • Initialize object
  • Applying Skin
  • Initialize from HTML table
  • Configuration with XML
  • Use API
  • Drag-n-drop
  • Copy data to clipboard in CSV format
  • Smart rendering with dynamic loading
  • Working with big datasets (PHP/MySQL sample with 10,000 records)
  • Add/Delete rows
  • Icons in header
  • Alternative coloring
  • Light mouse navigation mode
  • Auto height mode
  • Multirow Header
  • Complex content in headers
  • Attach events
  • Setting cells and columns properties
  • Reload grid content
  • Multiple grids per page

  • All Standard Edition samples...

    Features details

    Multirow header/footer

    Headers and footers in grid can contain multiple rows with various combination of colspan/rowspan. Each cell can contain either simple text or complex html objects.

    Smart Rendering

    Smart Rendering is a powerful feature which increases the performance of tables with great number of records. The main advantage of this mechanism is in the ability to render table data (this process is the slowest in DHTML) only when it gets to visible area of the grid (while scrolling). At the same time most API methods still work with invisible content.
    Using this feature together with dynamical loading you can work with really large amounts of data.

    Paginal output

    Paginal output is the easiest way to manage large amounts of data and make it comfortable for user to work with it. What is nice in dhtmlxGrid paginal output is that you can enable it in any grid just with single javascript command without the nesessity to change anything in grid configuration. Although dhtmlxGrid Standard edition is Paginal-Output ready (you can implement it using script API), full paging support, including the ability to use dhtmlxTabbar with it, was impelmented in Professional Edition only.

    dhtmlxDataProcessor

    dhtmlxDataProcessor add-in for dhtmlxGrid manages the process of loading/updating data on server side. It can be configured (with xml) for your particular datasource. Supports PHP4/5 with MySQL, ASP.NET with SQL Server. Its client side part can be used for any other server side technologies (we provide instructions for building server side processor).

    Extended cell - eXcell

    To allow greater flexibility, dhtmlxGrid uses unique mechanism called eXcell (extended Cell) to define data format and way of editing data for each column (cell). The grid control provides a wide variety of cell formats including text, image, combo box, list box, check box and radio buttons. If a cell contains multi-line text it can be edited with popup text editor or wrapped automatically in a cell.

    Along with standard ways (text, combo box, check box, etc.) of column editing/formatting, there are special types of exCell included into dhtmlxGrid package. For example, above table uses specific eXcell type to represent dynamic data in Sales and Prices columns. For details about usage and creation of new eXcell please reffer to the documentation

    Freezed Columns

    As it's necessary sometimes to keep some columns always visible, independent of horisontal scrolling position, we implemented the ability to freeze columns and split grid into two parts keeping the ability to navigate in both parts simultaniously.

    dhtmlxTreeGrid - grid and tree in one control

    dhtmlxTreeGrid is JavaScript UI component that combines tree view and editable grid. It is based on our dhtmlxGrid, and deploys all the functionality of dhtmlxGrid control enabling both hierarchical and tabular data presentation.
    For more information visit dhtmlxTreeGrid home page

    *dhtmlxTreeGrid distributed as a standalone product (includes dhtmlxGrid) or as an extension to dhtmlxGrid (if you already got dhtmlxGrid).

    Code Sample

    <link rel="STYLESHEET" type="text/css" href="dhtmlXGrid.css"> <script src="dhtmlXCommon.js"></script> <script src="dhtmlXGrid.js"></script> <script src="dhtmlXGridCell.js"></script> <script> var mygrid = null; function doOnLoad(){ var flds = ""; mygrid = new dhtmlXGridObject('gridbox'); mygrid.setImagePath("imgs/"); flds += "Sales,Book Title,Author,Price"; flds += ",In Store,Shipping,Bestseller,Date of Publication"; mygrid.setHeader(flds); mygrid.attachHeader("#rspan,Title,Author,#rspan,#rspan,#rspan,#rspan,#rspan"); mygrid.setInitWidths("50,150,120,80,80,80,80,200") mygrid.setColAlign("right,left,left,right,center,left,center,center") mygrid.setColTypes("dyn,ed,link,price,ch,coro,ra,ro"); mygrid.setColSorting("int,str,str,int,str,str,str,date") mygrid.setColumnColor("white,#d5f1ff,#d5f1ff") mygrid.setSkin("gray"); mygrid.init(); mygrid.loadXML("xml/grid_lnk.xml"); } </script> <body onload="doOnLoad()"> <div id="gridbox" height="250"></div>

    See also our Java treetable applet - TreeTable.

    © 1998-2007 Scand LLC. Last updated 10/03/07 RSS