google_sheets_translate_jp_to_eng.js

function myFunction() {
 // var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
//  var activeSheet = activeSpreadsheet.getActiveSheet();
  var ss = SpreadsheetApp.getActive();
  var allsheets = ss.getSheets();
  for(var s in allsheets){
    var targetSheet = allsheets[s];
    SpreadsheetApp.setActiveSheet(targetSheet);
     var lrow = targetSheet.getLastRow();
    var lcol = targetSheet.getLastColumn();
    for (var i = 1; i <= lrow; i++) {
        for (var j = 1; j <= lcol; j++) {
          var val = targetSheet.getRange(i, j).getValue();
            if ( val != "" && isNaN(val) ) {
                var activeCellText = val;
                var activeCellTranslation = LanguageApp.translate(activeCellText, 'ja', 'en');
                targetSheet.getRange(i, j).setValue(activeCellTranslation);
            }
        }
    }
  }
 /* var targetSheet = activeSheet;
  var lrow = targetSheet.getLastRow();
    var lcol = targetSheet.getLastColumn();
    for (var i = 1; i <= lrow; i++) {
        for (var j = 1; j <= lcol; j++) {
          var val = targetSheet.getRange(i, j).getValue();
            if ( val != "" && isNaN(val) ) {
                var activeCellText = val;
                var activeCellTranslation = LanguageApp.translate(activeCellText, 'ja', 'en');
                targetSheet.getRange(i, j).setValue(activeCellTranslation);
            }
        }
    } */
}