Reading and writing the Sheet data
Often you need to read and/or write data to/from the Sheet. Usually, use the
getValue
method to read a value from a cell and the getValues
method to read values from a range. The getValue
method returns a single value and the getValues
method returns a 2-dimensional array of values. To write single value and 2-dimensional array of values, use setValue
and setValues
methods respectively.
Get Learning Google Apps Script now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.