Google-Apps-Script Empty Pictures Copy -
i using following script, emedded in google-sheets file, copy charts images google-spreadsheet google-document. when open document there emty pictures inside (means can see margin if click on it).
know there similar questions here on stackoverflow there no real solutions problem. in addition, if copy pictures google-drive empty too. note don't want create new chart per script , copying data. in opinion bad solution.
function graphsreport(){ var doc = documentapp.create('auswertung ' + new date()); var charts = spreadsheetapp.getactivespreadsheet().getsheetbyname('auswertung').getcharts(); for(var = 0;i<charts.length;i++){ var chart = charts[i]; var picture = chart.getas('image/png'); picture.setname('chart' + i); //driveapp.createfile(picture); doc.getbody().appendimage(picture); } doc.saveandclose(); }
Comments
Post a Comment