💾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.
Last updated
Was this helpful?