DHTMLX Docs & Samples Explorer

### Using Grid API Methods

Manipulate grid content, appearance and functionality using wide range of Grid API methods

setHeaderCol copyRowContent (ex.:from first to selected) clearSelection setSelectedRow (ex.:second) setEditable (ex.:on/off) setUserData (ex.: to selected row) getUserData (ex.: of selected row) cells.getValue (ex.: of selected cell) cells2.getValue (ex.: of selected cell) moveRowDown (ex.:selected) moveRowUp (ex.:selected) getColumnCount getRowsNum getAllItemIds isItemExists (with id=14) setRowTextStyle (ex.:selected) setRowTextBold (ex.:selected) setRowTextNormal (ex.:selected) clearAll | setColumnIds (A,B) getColumnId (ex.:first) getColIndexById (ex.: B) setRowId (ex.: selected) getRowId (ex.:selected) getRowIndex (ex.:selected) getColWidth (ex.:of selected cell) getSelectedCellIndex getSelectedId deleteSelectedItem deleteRow (ex.: selected) setMultiselect (on/off) addRow (ex.:second position) selectRow (ex.:first one) selectCell (ex.: second cell of second row) attachToObject

Source

    <link rel="STYLESHEET" type="text/css" href="../../codebase/dhtmlxgrid.css">
    <link rel="stylesheet" type="text/css" href="../../codebase/skins/dhtmlxgrid_dhx_skyblue.css">
    <script  src="../../codebase/dhtmlxcommon.js"></script>
    <script  src="../../codebase/dhtmlxgrid.js"></script>
    <script  src="../../codebase/dhtmlxgridcell.js"></script>

    <table width="600px">
        <tr>
            <td width="400px" valign="top">
                <div id="gridbox" style="width:360px;height:250px;"></div>
            </td>
            <td valign="top">
                <div id="gridbox2" style="width:250px;height:250px;border:1px solid blue;overflow:auto"></div>
            </td>
        </tr>
        <tr>
            <td>
                <a href="javascript:mygrid.setHeaderCol(1,'New Header')">setHeaderCol</a><br>
                <a href="javascript:mygrid.copyRowContent(mygrid.getRowId(0),mygrid.getSelectedId())">copyRowContent (ex.:from first to selected)</a><br>
                <a href="javascript:mygrid.clearSelection()">clearSelection</a><br>
                <a href="javascript:mygrid.setSelectedRow(mygrid.getRowId(1))">setSelectedRow (ex.:second)</a><br>
                <a href="javascript:mygrid.setEditable(!mygrid.isEditable)">setEditable (ex.:on/off)</a><br>
                <a href="javascript:mygrid.setUserData(mygrid.getSelectedId(),'ud2','this value was set with script')">setUserData (ex.: to selected row)</a><br>
                <a href="javascript:alert(mygrid.getUserData(mygrid.getSelectedId(),'ud2'))">getUserData (ex.: of selected row)</a><br>
                <a href="javascript:alert(mygrid.cells(mygrid.getSelectedId(),mygrid.getSelectedCellIndex()).getValue())">cells.getValue (ex.: of selected cell)</a><br>
                <a href="javascript:alert(mygrid.cells2(mygrid.getRowIndex(mygrid.getSelectedId()),mygrid.getSelectedCellIndex()).getValue())">cells2.getValue (ex.: of selected cell)</a><br>
                <a href="javascript:mygrid.moveRowDown(mygrid.getSelectedId())">moveRowDown (ex.:selected)</a><br>
                <a href="javascript:mygrid.moveRowUp(mygrid.getSelectedId())">moveRowUp (ex.:selected)</a><br>
                <a href="javascript:alert(mygrid.getColumnCount())">getColumnCount</a><br>
                <a href="javascript:alert(mygrid.getRowsNum())">getRowsNum</a><br>
                <a href="javascript:alert(mygrid.getAllItemIds())">getAllItemIds</a><br>
                <a href="javascript:alert(mygrid.isItemExists('14'))">isItemExists (with id=14)</a><br>
                <a href="javascript:mygrid.setRowTextStyle(mygrid.getSelectedId(),'color:red;font-family:verdana;font-size:14px;')">setRowTextStyle (ex.:selected)</a><br>
                <a href="javascript:mygrid.setRowTextBold(mygrid.getSelectedId())">setRowTextBold (ex.:selected)</a><br>
                <a href="javascript:mygrid.setRowTextNormal(mygrid.getSelectedId())">setRowTextNormal (ex.:selected)</a><br>
                <a href="javascript:mygrid.clearAll()">clearAll</a><br>
            </td>
            <td>
                <a href="javascript:mygrid.setColumnIds('A,B')">setColumnIds (A,B)</a><br>
                <a href="javascript:alert(mygrid.getColumnId(0))">getColumnId (ex.:first)</a><br>
                <a href="javascript:alert(mygrid.getColIndexById('B'))">getColIndexById (ex.: B)</a><br>
                <a href="javascript:mygrid.setRowId(mygrid.getRowIndex(mygrid.getSelectedId()),'newid')">setRowId (ex.: selected)</a><br>
                <a href="javascript:alert(mygrid.getRowId(mygrid.getRowIndex(mygrid.getSelectedId())))">getRowId (ex.:selected)</a><br>
                <a href="javascript:alert(mygrid.getRowIndex(mygrid.getSelectedId()))">getRowIndex (ex.:selected)</a><br>
                <a href="javascript:alert(mygrid.getColWidth(mygrid.getSelectedCellIndex()))">getColWidth (ex.:of selected cell)</a><br>
                <a href="javascript:alert(mygrid.getSelectedCellIndex())">getSelectedCellIndex</a><br>
                <a href="javascript:alert(mygrid.getSelectedId())">getSelectedId</a><br>
                <a href="javascript:mygrid.deleteSelectedItem()">deleteSelectedItem</a><br>
                <a href="javascript:void(0)" onclick="mygrid.deleteRow(mygrid.getSelectedId())">deleteRow (ex.: selected)</a><br>
                <a href="javascript:mygrid.setMultiselect(!mygrid.selMultiRows)">setMultiselect (on/off)</a><br>
                <a href="javascript:void(mygrid.addRow(mygrid.getUID(),'text 1,text 2',1))">addRow (ex.:second position)</a><br>
                <a href="javascript:mygrid.selectRow(0)">selectRow (ex.:first one)</a><br>
                <a href="javascript:mygrid.selectCell(1,1)">selectCell (ex.: second cell of second row)</a><br>
                <a href="javascript:mygrid.attachToObject(document.getElementById('gridbox2'))">attachToObject</a><br>
            </td>
        </tr>
    </table>
    <script>mygrid = new dhtmlXGridObject('gridbox');
    mygrid.setImagePath("../../codebase/imgs/");
    mygrid.setHeader("Column A, Column B");
    mygrid.setInitWidths("100,250");
    mygrid.setColAlign("right,left");
    mygrid.setColTypes("dyn,ed");
    mygrid.setColSorting("str,str");
    mygrid.init();
    mygrid.setSkin("dhx_skyblue");
    mygrid.loadXML("../common/grid_16_rows_columns_manipulations.xml", function() {
        mygrid.selectRow(1);
    });</script>