Google Apps Script, copy one spreadsheet to another spreadsheet with formatting

by

Have you looked here:

https://developers.google.com/apps-script/reference/spreadsheet/sheet#copyTo(Spreadsheet)

copyTo(spreadsheet)

Copies the sheet to another spreadsheet. The destination spreadsheet can be the source. The new spreadsheet will have the name “Copy of [original spreadsheet name]”.

 var source = SpreadsheetApp.getActiveSpreadsheet();

 var sheet = source.getSheets()[0];

 var destination = SpreadsheetApp.openById("ID_GOES HERE");

 sheet.copyTo(destination);

More Related Contents:

  1. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  2. How to protect the Apps Script code in a Google spreadsheet?
  3. Is there a way to evaluate a formula that is stored in a cell?
  4. Automatic timestamp when a cell is filled out
  5. Apps Script: how to get hyperlink from a cell where there is no formula
  6. How to auto select range from a filter without having to manually enter it?
  7. Script to Change Row Color when a cell changes text
  8. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  9. You do not have permission to call openById
  10. Moving Files In Google Drive Using Google Script
  11. How to get onFormSubmit to trigger automatically?
  12. Copying a spreadsheet copies all linked files as well
  13. “SpreadsheetApp.getUi() cannot be called from this context”
  14. copy data from one sheet to another in google app script and append a row, one small issue
  15. Using built-in spreadsheet functions in a script
  16. Google App Scripts cannot be given Authorization or Permission
  17. How to get the correct range to set the value to a cell?
  18. Refresh data retrieved by a custom function in Google Sheet
  19. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  20. Dynamically creating spreadsheet menu items
  21. Increment Cell value by one by clicking
  22. Creating and Sending sheets in the same function
  23. email notification if cell is changed
  24. Dynamic selection options in Google Apps Script for forms
  25. Determine current user in Apps Script
  26. How to ignore empty cell values for getRange().getValues()
  27. Google apps script error: “You do not have permission to call protect” [duplicate]
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment