jspreadsheet v4 를 이용한 간단한 예제 > jquery

• 목록

<script src="https://bossanova.uk/jspreadsheet/v4/jexcel.js"></script>
<script src="https://jsuites.net/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://bossanova.uk/jspreadsheet/v4/jexcel.css" type="text/css" />
<link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" />


<div id='my-spreadsheet'></div>

<script>
var changed = function(instance, cell, x, y, value) {
var cellName = jexcel.getColumnNameFromId([x,y]);
//$('#log').append('New change on cell ' + cellName + ' to: ' + value + '');
        console.log( x + ":" + y + ":" + cellName + ':' + value + '');

lineData = js1.getRowData(y);
console.log(lineData);
    }

var js1 = jspreadsheet(document.getElementById('my-spreadsheet'), {
url:'json/vendor_goods.json.php?ec_code=<?=$ec_code;?>',
rowResize:true,
columns:[
            { name:'ec_code', title:'매출처코드', type:'number', width:100 },
            { name:'gg_code', title:'품목코드', type:'number', width:100 },
            { name:'vu_price', title:'개별단가', type:'number', width:150 }
        ],
onchange: changed
    });
</script>