💾app.dataRangeValuesFromSheet()

GAS ⟩ app ⟩ methods ⟩ dataRangeValuesFromSheet()

💾 程式

// 🔸 app.dataRangeValuesFromSheet(sheetName)
// ⭐️ 注意：data range 都是從 "A1" 開始算❗️ 
dataRangeValuesFromSheet(sheetName){
  return app.sheetByName(sheetName).getDataRange().getValues();
},

⬇️ 應用

• 國中成績一覽表

📘 手冊

• Range ⟩ .getValues() the values may be of type Number, Boolean, Date, or String, depending on the value of the cell, empty cells are represented by an empty string.