function readVerticalRange()

in apps_script/util.js [65:79]

• 15 lines of code
• 5 McCabe index (conditional complexity)

function readVerticalRange(rangeName, keyMap = {}, skipHeader = true) {
  sheet = SpreadsheetApp.getActiveSpreadsheet();
  range = sheet.getRangeByName(rangeName);
  var values = range.getValues();
  data = {};
  if (skipHeader) values = values.slice(1);
  for (const row of values) {
    key = cleanKey(row[0]);
    key = keyMap[key] || key;
    if (key) {
      data[key] = row.slice(1);
    }
  }
  return data;
}