Last updated 3 years ago
Was this helpful?
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.