View Source GoogleApi.Sheets.V4.Model.ValueRange (google_api_sheets v0.34.0)
Data within a range of the spreadsheet.
Attributes
-
majorDimension
(type:String.t
, default:nil
) - The major dimension of the values. For output, if the spreadsheet data is:A1=1,B1=2,A2=3,B2=4
, then requestingrange=A1:B2,majorDimension=ROWS
will return[[1,2],[3,4]]
, whereas requestingrange=A1:B2,majorDimension=COLUMNS
will return[[1,3],[2,4]]
. For input, withrange=A1:B2,majorDimension=ROWS
then[[1,2],[3,4]]
will setA1=1,B1=2,A2=3,B2=4
. Withrange=A1:B2,majorDimension=COLUMNS
then[[1,2],[3,4]]
will setA1=1,B1=3,A2=2,B2=4
. When writing, if this field is not set, it defaults to ROWS. -
range
(type:String.t
, default:nil
) - The range the values cover, in A1 notation. For output, this range indicates the entire requested range, even though the values will exclude trailing rows and columns. When appending values, this field represents the range to search for a table, after which values will be appended. -
values
(type:list(list(any()))
, default:nil
) - The data that was read or to be written. This is an array of arrays, the outer array representing all the data and each inner array representing a major dimension. Each item in the inner array corresponds with one cell. For output, empty trailing rows and columns will not be included. For input, supported value types are: bool, string, and double. Null values will be skipped. To set a cell to an empty value, set the string value to an empty string.
Summary
Functions
Unwrap a decoded JSON object into its complex fields.