copy spreadsheet without the form

Question

I am new bee trying to use google app scripts. I am trying to copy spreadsheet using

var copySheet=spreadSheetCurrent.copy(date.toString('yyyy-MM-dd'));

this is also making a copy of the form associated with this spreadsheet, can I just copy only the spreadsheet ?

You can create an empty one and copy all its data. Is it ok to you? If is I will post an example. — br araujo

br araujo br araujo · Accepted Answer · 2013-10-08T19:19:46

You can copy with this script:

function doCopy() {
  var srcSpread = SpreadsheetApp.openById("0AkkQD4hSd4KAdEdyZHM4Xzd3QjMwdDVxazVLOTBFN2c");
  var destSpread = SpreadsheetApp.create("Copy of Plan X");

  for(var idx in srcSpread.getSheets()) {
    srcSpread.getSheets()[idx].copyTo(destSpread);
  }
}

Shared here.

copy spreadsheet without the form

1 Answers