i need when copy sheet new spreadsheet. wanted paste values.
i creating .pdf copy of sheet copyto copy formula sheet.
function topdf() { var foldersave = driveapp.getfolderbyid('id'); var originalspreadsheet = spreadsheetapp.getactivespreadsheet().getsheetbyname("print_sheet_damir"); var radni_sheet_damir = spreadsheetapp.getactivespreadsheet().getsheetbyname("radni_sheet_damir"); var name = originalspreadsheet.getrange("c4").getvalue(); var id = radni_sheet_damir.getrange("e2").getvalue(); var newspreadsheet = spreadsheetapp.create("id_" + id + "_" + name); var sheet = spreadsheetapp.getactivespreadsheet().getactivesheet(); var projectname = spreadsheetapp.getactivespreadsheet(); var sheet = spreadsheetapp.getactivespreadsheet().getsheetbyname("print_sheet_damir"); sheet.copyto((newspreadsheet), {contentsonly: true}); newspreadsheet.getsheetbyname('sheet1').activate(); newspreadsheet.deleteactivesheet(); pdf = newspreadsheet.getblob(); var file = foldersave.createfile(pdf);
but
sheet.copyto((newspreadsheet), {contentsonly: true});
does not work me, please help.
from documentation, can check here on how use function copyto(spreadsheet). here sample code.
var source = spreadsheetapp.getactivespreadsheet(); var sheet = source.getsheets()[0]; var destination = spreadsheetapp.openbyid('id_goes here'); sheet.copyto(destination);
and copyto(destination, options)
// code below copy values of first 5 columns on 6th column. var sheet = spreadsheetapp.getactivesheet(); sheet.getrange("a:e").copyto(sheet.getrange("f1"), {contentsonly:true}); }
you can check tutorial on how copy spreadsheet values different spreadsheet.
for more information, check google appsscript documentation spreadsheet , related so question.
Comments
Post a Comment