google sheet helper functions

gistfile1.txt

var SHEET = SpreadsheetApp.getActiveSheet();

function toArray(){
  var arr = SHEET.getRange("A1:D1").getValues()[0];
  Logger.log(arr);
}

function toMatrix(){
  var hash = SHEET.getRange("A3:B5").getValues();
  Logger.log(hash);
}

function toHash(matrix){
  var hash = {};
  for (var i = 0; i < matrix.length; i ++){
    hash[matrix[i][0]] = matrix[i][1];
  }
  return hash;
}

function testHash(){
  var values = SHEET.getRange("A3:B5").getValues();
  Logger.log(toHash(values));
}