Skip to content Skip to sidebar Skip to footer

Jquery Copy From Excel To Multiple Input Fields

I have na excel sheet with the data: English | Spanish | Italian | French I'd like to be able to copy all these inputs and paste it to the form: Copy

jQuery

$('input').bind('paste', null, function(e){
    $this = $(this);

    setTimeout(function(){
        var columns = $this.val().split(/\s+/);
        $this.val(' ');
        var i;

        for(i=0; i < columns.length; i++){
            var name = columns[i].toLowerCase();
            $('input[name="' + name + '"]').val(columns[i]);
        }
    }, 0);
});

Here's a demo fiddle to look at : http://jsfiddle.net/adjit/3N94L/3/

Solution 2:

The clipboard is not going to allow this. You might want to look into a library like HandsOnTable which will parse the clipboard/excel data and run the paste into multiple inputs.

http://handsontable.com/

Post a Comment for "Jquery Copy From Excel To Multiple Input Fields"