问将数据从一个谷歌工作表复制到另一个工作簿

EN

/**
 * Retrieves all the rows in the active spreadsheet that contain Yes
 * in the Include column and copies them to the Report sheet.
 */

function MasterTracker() {
  var sSheet = SpreadsheetApp.getActiveSpreadsheet();
  var srcSheet = sSheet.getSheetByName("DARS");
  var tSheet = SpreadsheetApp.openById('DOC ID');
  var tarSheet = tSheet.getSheetByName("TrackerPilot");
  var srcData = srcSheet.getDataRange().getValues();  // get all values
  var sourceValues = [];

  for (var i=1; i<=srcSheet.getLastRow(); i++) {
    // i+1 is row number i is index in data array
    // A is column 1 so index is 0 in data array 
    if ( srcData[i][0] === 0 ) {  // assuming the value is a number?
      sourceValues.push(srcData[i].slice(4,21)); // Column E is index 4 and V (Not included) is index 21
    }
  }
  tarSheet.getRange(tarSheet.getLastRow()+1,1,sourceValues.length,sourceValues[0].length).setValues(sourceValues);  
};

function cloneGoogleSheet(ssA, ssB) {

 // source doc
  var sss = SpreadsheetApp.openById('Source Workbook ID');

// source sheet
  var ss = sss.getSheetByName('Import');

  // Get full range of data
  var SRange = ss.getDataRange();

  // get the data values in range
  var SData = SRange.getValues();

  var i = 0;
  var TData = [];
  for( i=0; i<SData.length; i++ ) {
    if( SData[i][2] === 0 ) { // Column C = 0
      TData.push(SData[i]);
    }
  }

  // target spreadsheet
  var tss = SpreadsheetApp.openById('Target WorkbookID');

  // target sheet
  var ts = tss.getSheetByName('Master2');

  
  // set the target range to the values of the source data
  ts.getRange(1,1,TData.length,TData[0].length).setValues(TData);  // Over write
  // Append ts.getRange(ts.getLastRow()+1,1,TData.length,TData[0].length).setValues(TData);

};