thwippp
1/13/2017 - 7:58 PM

Get an array of cell values and put them in a 2D array (FAST & EASY)-- Google Sheets

Get an array of cell values and put them in a 2D array (FAST & EASY)-- Google Sheets

/********** Gets values from a sheet and iterates them into a 2D Array **********/

function array2dFast () {
  
  /********** Sets up sheet **********/
  var ss = SpreadsheetApp.getActiveSpreadsheet();  // Gets active spreadsheet
  var sheet = ss.getSheetByName("SHEET_NAME");  // Gets sheet by name-- RENAME
  
  /********** Sets up data range **********/
  var dataRange = ss.getRangeByName("DATA_RANGE_NAME").getValues();  // The range of cells that you want to add to the 2D array
                                                        // ADD NAMED RANGE IN SHEET
  
  // Logger.log(dataRange[0][0]);  // Get a cell's value
}