Breaking News: Grepper is joining You.com. Read the official announcement!

load data table app script

Angry Anteater answered on March 22, 2021 Popularity 2/10 Helpfulness 1/10

answer load data table app script

related load data table app script

load data table app script

Comment

    <script type='text/javascript'>
    $(document).ready(function(){
        var runner = google.script.run.withFailureHandler(onFailure);
        runner.withSuccessHandler(onSuccess).getData();
    });
    var onSuccess = function(data){
        var aDataSet = data.slice(1);  // all except header


        var head = [];  // headers
        data[0].forEach(function(e){
            head.push({'sTitle': e});
        });

        $('#demo').html( '<table cellpadding="0" cellspacing="0" border="0" class="display" id="example"></table>' );
        $('#example').dataTable( {
            "aaData": aDataSet,
            "aoColumns": head
        });
    }
    var onFailure = function(err){
        alert(err.message);
    }
    </script>

Popularity 2/10 Helpfulness 1/10 Language javascript

Source: stackoverflow.com

Tags: javascript load script

Link to this answer
Share Copy Link

Contributed on Mar 22 2021

Angry Anteater

0 Answers Avg Quality 2/10

Closely Related Answers

load data table app script

Comment

function getData(){
   var data = SpreadsheetApp.openById('YourSheetID').getSheetByName('YourSheetName').getDataRange().getValues();
   return data;
}

Popularity 2/10 Helpfulness 1/10 Language javascript

Source: stackoverflow.com

Tags: load script javascript

Link to this answer
Share Copy Link

Contributed on Mar 22 2021

Angry Anteater

0 Answers Avg Quality 2/10

load data table app script

Contents

More Related Answers

load data table app script

Closely Related Answers

load data table app script

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.