getColumnRange()

in src/connectors/sheets-connector.js [187:200]

• 12 lines of code
• 4 McCabe index (conditional complexity)

  getColumnRange(tabId, propertyKey, includeSkipRows) {
    let tabConfig = this.tabs[tabId];
    let sheet = this.getSheet(tabId);
    let columnIndex = this.getPropertyIndex(tabId, propertyKey);
    let numRows = includeSkipRows ?
      sheet.getLastRow() : sheet.getLastRow() - tabConfig.skipRows;
    let rowStart = includeSkipRows ? 1 : tabConfig.skipRows + 1;

    assert(columnIndex, `Unable to get column index for property '${propertyKey}'`);
    assert(numRows >= 1, 'The number of rows in the range must be at least 1');

    let range = sheet.getRange(rowStart, columnIndex, numRows, 1);
    return range;
  }