DHTMLX Docs & Samples Explorer

Keymap - excel

There is an opportunity to set one of two keymaps: excel or access. Excel keymap is presented in the sample below:

The excel keymap provides the following keys for navigation:

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>
<script  src="../../codebase/ext/dhtmlxgrid_keymap_excel.js"></script>    
<style>
    div.gridbox_light table.obj tr.rowselected td.cellselected, div.gridbox table.obj td.cellselected {
        background-color:#ACCADD;
    }
</style>
 
 
 
<div id="gridbox"  style="width:600px; height:250px; background-color:white;overflow:hidden"></div>
 
<script>
mygrid = new dhtmlXGridObject('gridbox');
mygrid.setImagePath("../../codebase/imgs/");
mygrid.setHeader("Sales,Book Title,Author,Price,In Store,Shipping");
mygrid.setInitWidths("60,150,100,80,80,80");
mygrid.enableAutoWidth(true);
mygrid.setColAlign("right,left,left,right,center,left");
mygrid.setColTypes("dyn,edtxt,ed,price,ch,co");
mygrid.enableMultiselect(true);
mygrid.init();
mygrid.setSkin("light");
mygrid.loadXML("../common/100.xml");
</script>