Is there a way to create chart and move it to own sheet? As per API docs I
have browsed there is no such option ...
I have tried to do it by creating such chart manually and then copy it, but
the thing is that I cannot access this chart. There are code samples I have
tried:
1. By sheet name:
var ss = SpreadsheetApp.getActiveSpreadsheet();
ss.getSheetByName('Chart');
2. By getting all sheets and then getting all charts of those sheets:
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
for (var s in sheets) {
var charts = sheets[s].getCharts();
for (var c in charts) {
Browser.msgBox(charts[c]);
}
}
3. By attempt to duplicate chart sheet:
var ss = SpreadsheetApp.getActiveSpreadsheet();
ss.duplicateActiveSheet();
First two just didn't find a chart. Last one failed during execution with
'Illegal Argument' exception ...
Is there a way how to create chart with it's own sheet?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
