CODEWITHSUNDEEP
javascriptjqueryexcel
Grasper
Grasper

Reputation: 1313

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:

<input type="text" name="english">
<input type="text" name="spanish">
<input type="text" name="italian">
<input type="text" name="french">

so far when I copy all the data it will all paste into first input field. I'm asking this before I start coding as I'm not sure if it's even possible to do.

Any directions appreciated!

Upvotes: 1

Views: 5792

Answers (2)

Adjit
Adjit

Reputation: 10305

Upon your clarification, you can use jQuery to capture the paste action into anyone of those fields. Then simply parse and send it to the right input box.

HTML

<input type="text" name="english">
<input type="text" name="spanish">
<input type="text" name="italian">
<input type="text" name="french">

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/

Upvotes: 3

BReal14
BReal14

Reputation: 1584

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/

Upvotes: 2

Related Questions