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.