💾 sheet.rangeByRect()

GAS ⟩ app ⟩ prototypes ⟩ sheet.prototype ⟩ .rangeByRect()

💾 程式

• ⬆️ 需要： RangeRect

  // 🔸 sheet.rangeByRect(rect: RangeRect)
  // require: RangeRect
  rangeByRect(rect){
    const range = this.getRange(...rect.toArray());
    range.__proto__ = app.range.prototype;           // ⭐️ extend range
    return range;
  },

⬇️ 應用

• 各班平均及前三名

👥 相關

• 簡化選取 Range