Range
Google Apps Script class for Google Sheet
Last updated
Was this helpful?
Google Apps Script class for Google Sheet
Last updated
Was this helpful?
โฉ โฉ Range
Range ็ไฝ็ฝฎ่ณ่จ๏ผ
- starting row index.
- starting column index.
- number of rows.
- number of columns.
้ธๅ Range๏ผ
๐พ sheet.rangeByRect() - ็ฐกๅ Range ็้ธๅใ
range. - ๅฆๆไฝ็งป็้ๆฒๆ่จญๅฅฝ๏ผๆๅบ็พ้กไผผไปฅไธ้ฏ่ชค๏ผ โ Exception: The starting row of the range is too small.
่จญๅฎๅฒๅญๆ ผๅ ฌๅผ๏ผ
ๅไฝตๅฒๅญๆ ผ๏ผ
ๆฐดๅนณๅไฝต๏ผ (ๅฆๆๆๅฅฝๅนพๅ๏ผๆฏๅๆๅๅฅๅไฝต)
ๅ็ดๅไฝต๏ผ
่จญๅฎๅญ้ซ๏ผ
ๅญ้ซ้ก่ฒ๏ผ, , , ...
ๅญ้ซๅคงๅฐ๏ผ
ๅญ้ซ็ฒ็ดฐ๏ผ
ๅไธๅๅฒๅญๆ ผๅ ง่จญๅฎไธๅ็ๅญ้ซ๏ผ range.setRichTextValue() โญ๏ธ
่จญๅฎ้ก่ฒ๏ผ
ๅฒๅญๆ ผ่ๆฏ่ฒ๏ผ
ๆๅญๅฐ้ฝ๏ผ
ๆฐดๅนณ๏ผ,
ๅ็ด๏ผ,
โญ๏ธ - row/column number โ A1 notation
GAS โฉ (enum)
โฉ
- ๅๅณ้กไผผ "A1:E2"
็ๅญไธฒใ
- another range.
- sheet (Sheet) this range belongs to.
- collection of one or more instances in the same sheet.
Sheet โฉ
- internal data structure of a cell
- row/col number to A1/R1C1 notation.
- row number of a cell.
- column number of a cell.