Getting Cannot call method "getRange" of null error

Question

var METADATA_SHEET_NAME = 'MetaData';

function readMetaData() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName(METADATA_SHEET_NAME);
  var range = sheet.getRange(1, 2);
  var fixVersion = range.getValue();
  Logger.log(fixVersion);
  return fixVersion;  
}

In my current google script, I already have Sheet with Name MetaData. I am storing a sheet name in variable METADATA_SHEET_NAME. if I pass sheet name directly in getSheetByName() method, it works perfectly but when I am passing variable name(in which I have stored sheet name) it is giving

TypeError: Cannot call method "getRange" of null.

Indicates a problem with a sheet named MetaData. Do you have a sheet named MetaData with the same capitalization? — ScampMichael, Jul 04 '17 at 11:18
Try placing Logger.log(METADATA_SHEET_NAME); in your function and seeing what it returns. — ScampMichael, Jul 04 '17 at 14:59

score 1 · Answer 1 · answered Jul 06 '17 at 12:41

Check for typos as it's working for me. It's okay to assign the sheet name to a variable.

Here I have a sheet named 'Sheet1' which I assigned to METADATA_SHEET_NAME variable. Now I'm going to fetch value from row 1 col 2 as per your code.

[17-07-06 05:17:16:829 PDT] Response1

score 0 · Answer 2 · answered Jul 04 '17 at 10:39

0

Global variables in Google apps script aren't persistent. see top answer here for more info

Check out this blog post for loading global variables if you really need to

answered Jul 04 '17 at 10:39

Andy_Mac

1
1

Getting Cannot call method "getRange" of null error

2 Answers2