CODEWITHSUNDEEP
javascriptgoogle-sheetssheetrock
Leonardo Lamanna
Leonardo Lamanna

Reputation: 1

How can I retrieve images from Google Sheets in HTML output using sheetrock.js?

I Can't get images from Google Sheets in the HTML output, by sheetrock.js

I have implemented this code:

    var mySpreadsheet = 'https://docs.google.com/spreadsheets/d/SHEET_ID/edit#gid=0';
    var sheetrockResultsList = Handlebars.compile($('#compileMe').html());

    $('#resultsList').sheetrock({
    url: mySpreadsheet,
    query: 'select A,B,C,D,E',
    callback : makeTable,       
    });

    function makeTable(error, options, response) {
    $(options.user.target).DataTable({
    pageLength: 30,
    lengthChange: false,
    searching: true,
    paging:false,
    scrollY: "60vh", 
    scrollCollapse: true,
    sscrollX: false,
    ordering: false,
    language: {
        processing: "Loading...",
        search: "",
    info: "",
    infoEmpty: "No results",
    infoFiltered: ""
        }
    });}
    </script>

which works correctly and generates the expected output for all the data... except for the images included in the sheet!

I've read on Github, that it can be done through a "callback", but I'm a real noob on this and I don't understand how to implement it (!?)

Could someone give me a hand on this... or maybe point me to an example page where this is done and serve me as a reference example?

Thanks in advance!

Upvotes: 0

Views: 163

Answers (0)

Related Questions