pdf generation - google script paste value only -


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