Other resources

  • jExcel CE
    Jexcel community edition
  • jTools
    Web components, utilities and plugins
  • Handling events

    Various tracking javascript methods

    Binding tracking events on your javascript spreadsheet


    Log:



    Source code

    <html>
    <script src="https://jexcel.net/v3/jexcel.js"></script>
    <script src="https://jexcel.net/v3/japp.js"></script>
    <link rel="stylesheet" href="https://jexcel.net/v3/jexcel.css" type="text/css" />
    <link rel="stylesheet" href="https://jexcel.net/v3/japp.css" type="text/css" />
    
    <div id="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 + '
    '); } var beforeChange = function(instance, cell, x, y, value) { var cellName = jexcel.getColumnNameFromId([x,y]); $('#log').append('The cell ' + cellName + ' will be changed
    '); } var insertedRow = function(instance) { $('#log').append('Row added
    '); } var insertedColumn = function(instance) { $('#log').append('Column added
    '); } var deletedRow = function(instance) { $('#log').append('Row deleted
    '); } var deletedColumn = function(instance) { $('#log').append('Column deleted
    '); } var sort = function(instance, cellNum, order) { var order = (order) ? 'desc' : 'asc'; $('#log').append('The column ' + cellNum + ' sorted by ' + order + '
    '); } var resizeColumn = function(instance, cell, width) { $('#log').append('The column ' + cell + ' resized to width ' + width + ' px
    '); } var resizeRow = function(instance, cell, height) { $('#log').append('The row ' + cell + ' resized to height ' + height + ' px
    '); } var selectionActive = function(instance, x1, y1, x2, y2, origin) { var cellName1 = jexcel.getColumnNameFromId([x1, y1]); var cellName2 = jexcel.getColumnNameFromId([x2, y2]); $('#log').append('The selection from ' + cellName1 + ' to ' + cellName2 + '
    '); } var loaded = function(instance) { $('#log').append('New data is loaded
    '); } var moveRow = function(instance, from, to) { $('#log').append('The row ' + from + ' was move to the position of ' + to + '
    '); } var moveColumn = function(instance, from, to) { $('#log').append('The col ' + from + ' was move to the position of ' + to + '
    '); } var blur = function(instance) { $('#log').append('The table ' + $(instance).prop('id') + ' is blur
    '); } var focus = function(instance) { $('#log').append('The table ' + $(instance).prop('id') + ' is focus
    '); } var data = [ ['Mazda', 2001, 2000, '2006-01-01'], ['Pegeout', 2010, 5000, '2005-01-01'], ['Honda Fit', 2009, 3000, '2004-01-01'], ['Honda CRV', 2010, 6000, '2003-01-01'], ]; jexcel(document.getElementById('spreadsheet'), { data:data, rowResize:true, columnDrag:true, columns: [ { type: 'text', width:'200' }, { type: 'text', width:'100' }, { type: 'text', width:'100' }, { type: 'calendar', width:'100' }, ], onchange: changed, onbeforechange: beforeChange, oninsertrow: insertedRow, oninsertcolumn: insertedColumn, ondeleterow: deletedRow, ondeletecolumn: deletedColumn, onselection: selectionActive, onsort: sort, onresizerow: resizeRow, onresizecolumn: resizeColumn, onmoverow: moveRow, onmovecolumn: moveColumn, onload: loaded, onblur: blur, onfocus: focus, }); </script> </html>


    Advanced Example

    Update the chart on every change in your spreadsheet, using the onchange handler



    Source code

    <html>
    <script src="https://jexcel.net/v3/jexcel.js"></script>
    <script src="https://jexcel.net/v3/japp.js"></script>
    <link rel="stylesheet" href="https://jexcel.net/v3/jexcel.css" type="text/css" />
    <link rel="stylesheet" href="https://jexcel.net/v3/japp.css" type="text/css" />
    
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
    <script src="https://code.highcharts.com/highcharts.js"></script>
    
    <div id="spreadsheet1"></div>
    
    <script>
    var data1 = [
        ['Tokyo', 7.0, 6.9, 9.5, 14.5, 18.2, 21.5, 25.2, 26.5, 23.3, 18.3, 13.9, 9.6],
        ['New York', -0.2, 0.8, 5.7, 11.3, 17.0, 22.0, 24.8, 24.1, 20.1, 14.1, 8.6, 2.5],
        ['Berlin', -0.9, 0.6, 3.5, 8.4, 13.5, 17.0, 18.6, 17.9, 14.3, 9.0, 3.9, 1.0],
        ['London', 3.9, 4.2, 5.7, 8.5, 11.9, 15.2, 17.0, 16.6, 14.2, 10.3, 6.6, 4.8],
    ];
    
    var update = function (instance, cell, x, y, value) {
        // If the related series does not exists create a new one
        if (! chart.series[y]) {
            // Create a new series row
            var row = [];
            for (i = 1; i < data1[y].length; i++) {
                row.push(parseFloat(data1[y][i]));
            }
            // Append new series to the chart
            chart.addSeries({ name:data1[y][0], data:row });
        } else {
            if (x == 0) {
                // Update legend
                chart.series[y].update({ name:value });
            } else {
                // Update chart data
                chart.series[y].data[x-1].update({ y:parseFloat(value) });
            }
        }
    }
    
    jexcel(document.getElementById('spreadsheet1'), {
        data:data1,
        columns: [
            { type: 'text', width:'200' },
        ],
        onchange:update,
    });
    
    var chart = null;
    
    chart = Highcharts.chart('container', {
        title: {
            text: 'Monthly Average Temperature',
            x: -20 //center
        },
        subtitle: {
            text: 'Source: WorldClimate.com',
            x: -20
        },
        xAxis: {
            categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
                'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
        },
        yAxis: {
            title: {
                text: 'Temperature (°C)'
            },
            plotLines: [{
                value: 0,
                width: 1,
                color: '#808080'
            }]
        },
        tooltip: {
            valueSuffix: '°C'
        },
        legend: {
            layout: 'vertical',
            align: 'right',
            verticalAlign: 'middle',
            borderWidth: 0
        },
        series: [{
            name: 'Tokyo',
            data: [7.0, 6.9, 9.5, 14.5, 18.2, 21.5, 25.2, 26.5, 23.3, 18.3, 13.9, 9.6]
        }, {
            name: 'New York',
            data: [-0.2, 0.8, 5.7, 11.3, 17.0, 22.0, 24.8, 24.1, 20.1, 14.1, 8.6, 2.5]
        }, {
            name: 'Berlin',
            data: [-0.9, 0.6, 3.5, 8.4, 13.5, 17.0, 18.6, 17.9, 14.3, 9.0, 3.9, 1.0]
        }, {
            name: 'London',
            data: [3.9, 4.2, 5.7, 8.5, 11.9, 15.2, 17.0, 16.6, 14.2, 10.3, 6.6, 4.8]
        }]
    });
    </script>
    </html>