Crop sheets feature about google-apps-script-snippets HOT 1 OPEN

function crop(sheet) {
  sheet = sheet || SpreadsheetApp.getActiveSheet();
  var lRow = sheet.getLastColumn();
  var lCol = sheet.getLastColumn();
  sheet.deleteRows(lRow, sheet.getMaxRows() - lRow);
  sheet.deleteColumns(lCol, sheet.getMaxColumns() - lCol);
}

function cropAll(){
  SpreadsheetApp.getActive().getSheets().forEach(function(sheet){
    try{
      crop(sheet);
    }catch(err){
      console.warn(err);
    }
  })
}

function detectMaxRows(){
  var res = {name: '', max : 0};
  SpreadsheetApp.getActive().getSheets().forEach(function(sheet){
    try{
      var lr = sheet.getLastRow();
      if(lr > res.max){
        res.max = lr;
        res.name = sheet.getName();
      }
    }catch(err){
      console.warn(err);
    }
  })
  Logger.log(res);
}