title: Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
body: <p>Hopefully this question has not already been answered.  I have spent a considerable amount of time searching, and although I have found similar posts, none have done exactly what I am trying to do.</p>
  
  <p>I would like to use Google Apps Script to copy a single sheet from a Google spreadsheet into a different Google spreadsheet, and I want to retain formatting (including merged cells).  Is there any way to do this?  I have tried the following functions:</p>
  
  <p>copyTo()
  copyFormatToRange()</p>
  
  <p>but these methods only work within the same spreadsheet and do not allow data to be copied between different spreadsheets.  Does anyone have any suggestions?  Thanks!</p>