|
virtual System.Collections.Generic.IList< BandedRange > | BandedRanges [get, set] |
| The banded (alternating colors) ranges on this sheet. More...
|
|
virtual BasicFilter | BasicFilter [get, set] |
| The filter on this sheet, if any. More...
|
|
virtual System.Collections.Generic.IList< EmbeddedChart > | Charts [get, set] |
| The specifications of every chart on this sheet. More...
|
|
virtual System.Collections.Generic.IList< DimensionGroup > | ColumnGroups [get, set] |
| All column groups on this sheet, ordered by increasing range start index, then by group depth. More...
|
|
virtual System.Collections.Generic.IList< ConditionalFormatRule > | ConditionalFormats [get, set] |
| The conditional format rules in this sheet. More...
|
|
virtual System.Collections.Generic.IList< GridData > | Data [get, set] |
| Data in the grid, if this is a grid sheet. More...
|
|
virtual System.Collections.Generic.IList< DeveloperMetadata > | DeveloperMetadata [get, set] |
| The developer metadata associated with a sheet. More...
|
|
virtual System.Collections.Generic.IList< FilterView > | FilterViews [get, set] |
| The filter views in this sheet. More...
|
|
virtual System.Collections.Generic.IList< GridRange > | Merges [get, set] |
| The ranges that are merged together. More...
|
|
virtual SheetProperties | Properties [get, set] |
| The properties of the sheet. More...
|
|
virtual System.Collections.Generic.IList< ProtectedRange > | ProtectedRanges [get, set] |
| The protected ranges in this sheet. More...
|
|
virtual System.Collections.Generic.IList< DimensionGroup > | RowGroups [get, set] |
| All row groups on this sheet, ordered by increasing range start index, then by group depth. More...
|
|
virtual System.Collections.Generic.IList< Slicer > | Slicers [get, set] |
| The slicers on this sheet. More...
|
|
virtual string | ETag [get, set] |
| The ETag of the item. More...
|
|
string | ETag |
|
A sheet in a spreadsheet.
virtual System.Collections.Generic.IList<GridData> Google.Apis.Sheets.v4.Data.Sheet.Data |
|
getset |
Data in the grid, if this is a grid sheet.
The number of GridData objects returned is dependent on the number of ranges requested on this sheet. For example, if this is representing Sheet1
, and the spreadsheet was requested with ranges Sheet1!A1:C10
and Sheet1!D15:E20
, then the first GridData will have a startRow/startColumn of 0
, while the second one will have startRow 14
(zero-based row 15), and startColumn 3
(zero-based column D).