Other resources

  • jExcel CE
    Jexcel community edition
  • jTools
    Web components, utilities and plugins
  • Working with comments in your javascript spreadsheet

    jExcel Pro javascript vanilla spreadsheet plugin allows the user to set custom comments for each individual cells. By allowComments in the initialization, the user will be able to add comments in the rigth click contextMenu.

    Programmatically comments

    To apply comments via javascript, you can use the methods setComments or getComments, as follow:

    mySpreadsheet.setComments('A1', 'This is the comments from A1');
    mySpreadsheet.getComments('A1');
    mySpreadsheet.setComments('A1', '');

    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 data1 = [
        ['US', 'Cheese', '2019-02-12'],
        ['CA', 'Apples', '2019-03-01'],
        ['CA', 'Carrots', '2018-11-10'],
        ['BR', 'Oranges', '2019-01-12'],
    ];
    
    mySpreadsheet = jexcel(document.getElementById('spreadsheet'), {
        data:data1,
        columns: [
            { type: 'dropdown', url:'/v3/countries', width:300, },
            { type: 'text', width:200, },
            { type: 'calendar', width:100, }
         ],
         allowComments:true,
    });
    </script>
    </html>