Function copyFromOther

GettingandSettingData.js:38–51

()

}

function copyFromOther(){
  const id = "1eVS5x6R70XPbqMfBPfyzktdg2AeVTrPMnkfj1gXTHS4";
  const s = SpreadsheetApp.openById(id);
  const sheet = s.getSheets()[0];
  const lastColumn = sheet.getLastColumn();
  const lastRow = sheet.getLastRow();
  const range = sheet.getRange(1, 1, lastRow, lastColumn); // Define Full Range with Last Row and Last Column 
  const data = range.getValues(); // Get all values 
  Logger.log(data);
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const newSheet = ss.insertSheet();
  const newRange = newSheet.getRange(1,1,range.getNumRows(),range.getNumColumns());
  newRange.setValues(data);
}