One of our customers asked us how to paste copied records from Excel in Wijmo Grid using Ctrl + v key. In this blog, we'll discuss a very simple approach to do the same. The idea for this implementation is :

  1. Get Clipboard Data
  2. Break it down into a two dimensional array with rows and columns
  3. Push this array one by one into the grid data.

Since the pasting operation is usually done using Ctrl + v, we will handle the KeyDown event of the grid.

$("#demo").keydown(function (e)  
{  
    if (e.ctrlKey && (e.keyCode == 86)) {  
        // get the clipboard text  
        var clipText = window.clipboardData.getData('Text');  
        // split into rows  
        clipRows = clipText.split(String.fromCharCode(13));  
        // split rows into columns  
        for (i = 0; i < clipRows.length; i++) {  
            clipRows[ i ] = clipRows[ i ].split(String.fromCharCode(9));  
        }  

        var $grid = $('#demo');  
        data = $grid.wijgrid("data");  

        for (var i = 0; i < clipRows.length-1; i++) {  
            data.push(clipRows[ i ]);  
        }  

        $grid.wijgrid('ensureControl', true);  
        $('#demo').wijgrid('doRefresh');  

    }  
});

Download Sample for detailed implementation. Download Sample