javascript - Returning a serverside datatable to client with google App Script -
javascript - Returning a serverside datatable to client with google App Script -
i want homecoming datatable created in google apps script info spreadsheet client. utilize succeshandler info , utilize create chart. problem have info null. seems can't homecoming datatable object client page.
i need send client, because google apps script deprecating uiapp functions need google.visualization functions in client.
code.gs
function doget() { homecoming htmlservice.createhtmloutputfromfile('index.html') .setsandboxmode(htmlservice.sandboxmode.iframe);} function getdatatable() { var bestanden = driveapp.searchfiles('title contains "' + "kwalrap" + '"'); while (bestanden.hasnext()) { var bestand = bestanden.next(); var docid = ( bestand.getid() ); logger.log(docid); }; var sheets= spreadsheetapp.openbyid(docid).getsheets(); //vanaf sheet 0. tot hij bij de laatset sheet is. dan steeds 2 sheets verder. for(var j = 0; j < 2; j = j+1) { var sheet = sheets[j]; //logger.log(sheet.getsheetname()); var range = sheet.getrange(2,1,sheet.getlastrow(),8); var inforange = sheet.getrange(2,1,1,8); var values = range.getvalues(); var infovalues = inforange.getvalues(); var info = charts.newdatatable() .addcolumn(charts.columntype.string, "tijd") .addcolumn(charts.columntype.number, "dco") .addcolumn(charts.columntype.number, "dcp") .addcolumn(charts.columntype.number, "dct") .addcolumn(charts.columntype.number, "dcz") .addcolumn(charts.columntype.number, "ldc") .addcolumn(charts.columntype.number, "lv") for(var = 0; < sheet.getlastrow()-1; i++) { data.addrow([values[i][0],values[i][1],values[i][2],values[i][3],values[i][4],values[i][5],values[i][6]]); logger.log(values[i]); } var datatable = data.build(); homecoming datatable; // homecoming json.stringify(values); } } index.html
<html> <head> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["corechart"]}); function onsuccess(data) { var options = { title: 'why doesn't work' }; new google.visualization.linechart( document.getelementbyid('visualization_div')).draw(data, options); } google.script.run.withsuccesshandler(onsuccess) .getdatatable(); </script> </head> <body> <div id="visualization_div" style="width: 600px; height: 380px;';"></div> </body> </html> why info variable null in onsucceshandler , how datatable in client
thanks help
its because need homecoming plain javascript array, not info table purely server-side object.
javascript google-apps-script datatable google-apps
Comments
Post a Comment