excel to jquery table

paste excel data and convert to html table

by abubelinha

HTML

<textarea rows=15 cols=30 id="excel_data">
Paste your excel seleced grid here
</textarea>
<input type=button value=clickme id="procesar"></input>
<br>code taken from <a href="http://stackoverflow.com/a/2006514/710788" target=_blank>stackoverflow</a>, but see also <a href="http://handsontable.com/" target=_blank>handsontable</a>
    <div id="excel_table"><hr>Tabla<hr></div>

JavaScript

$("#procesar").click(function(){
//alert('click');
var data = $('#excel_data').val();
var rows = data.split("\n");

var table = $('<table border=1 />');

for(var y in rows) {
    var cells = rows[y].split("\t");
    var row = $('<tr />');
    for(var x in cells) {
        row.append('<td>'+cells[x]+'</td>');
    }
    table.append(row);
}

// Insert into DOM
$('#excel_table').html(table);

});