sheets  v4
Properties | List of all members
Google.Apis.Sheets.v4.Data.Sheet Class Reference

A sheet in a spreadsheet. More...

Inheritance diagram for Google.Apis.Sheets.v4.Data.Sheet:
Google::Apis::Requests::IDirectResponseSchema

Properties

virtual System.Collections.Generic.IList< BandedRangeBandedRanges [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< EmbeddedChartCharts [get, set]
 The specifications of every chart on this sheet. More...
 
virtual System.Collections.Generic.IList< DimensionGroupColumnGroups [get, set]
 All column groups on this sheet, ordered by increasing range start index, then by group depth. More...
 
virtual System.Collections.Generic.IList< ConditionalFormatRuleConditionalFormats [get, set]
 The conditional format rules in this sheet. More...
 
virtual System.Collections.Generic.IList< GridDataData [get, set]
 Data in the grid, if this is a grid sheet. More...
 
virtual System.Collections.Generic.IList< DeveloperMetadataDeveloperMetadata [get, set]
 The developer metadata associated with a sheet. More...
 
virtual System.Collections.Generic.IList< FilterViewFilterViews [get, set]
 The filter views in this sheet. More...
 
virtual System.Collections.Generic.IList< GridRangeMerges [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< ProtectedRangeProtectedRanges [get, set]
 The protected ranges in this sheet. More...
 
virtual System.Collections.Generic.IList< DimensionGroupRowGroups [get, set]
 All row groups on this sheet, ordered by increasing range start index, then by group depth. More...
 
virtual System.Collections.Generic.IList< SlicerSlicers [get, set]
 The slicers on this sheet. More...
 
virtual string ETag [get, set]
 The ETag of the item. More...
 
- Properties inherited from Google::Apis::Requests::IDirectResponseSchema
string ETag
 

Detailed Description

A sheet in a spreadsheet.

Property Documentation

◆ BandedRanges

virtual System.Collections.Generic.IList<BandedRange> Google.Apis.Sheets.v4.Data.Sheet.BandedRanges
getset

The banded (alternating colors) ranges on this sheet.

◆ BasicFilter

virtual BasicFilter Google.Apis.Sheets.v4.Data.Sheet.BasicFilter
getset

The filter on this sheet, if any.

◆ Charts

virtual System.Collections.Generic.IList<EmbeddedChart> Google.Apis.Sheets.v4.Data.Sheet.Charts
getset

The specifications of every chart on this sheet.

◆ ColumnGroups

virtual System.Collections.Generic.IList<DimensionGroup> Google.Apis.Sheets.v4.Data.Sheet.ColumnGroups
getset

All column groups on this sheet, ordered by increasing range start index, then by group depth.

◆ ConditionalFormats

virtual System.Collections.Generic.IList<ConditionalFormatRule> Google.Apis.Sheets.v4.Data.Sheet.ConditionalFormats
getset

The conditional format rules in this sheet.

◆ Data

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).

◆ DeveloperMetadata

virtual System.Collections.Generic.IList<DeveloperMetadata> Google.Apis.Sheets.v4.Data.Sheet.DeveloperMetadata
getset

The developer metadata associated with a sheet.

◆ ETag

virtual string Google.Apis.Sheets.v4.Data.Sheet.ETag
getset

The ETag of the item.

◆ FilterViews

virtual System.Collections.Generic.IList<FilterView> Google.Apis.Sheets.v4.Data.Sheet.FilterViews
getset

The filter views in this sheet.

◆ Merges

virtual System.Collections.Generic.IList<GridRange> Google.Apis.Sheets.v4.Data.Sheet.Merges
getset

The ranges that are merged together.

◆ Properties

virtual SheetProperties Google.Apis.Sheets.v4.Data.Sheet.Properties
getset

The properties of the sheet.

◆ ProtectedRanges

virtual System.Collections.Generic.IList<ProtectedRange> Google.Apis.Sheets.v4.Data.Sheet.ProtectedRanges
getset

The protected ranges in this sheet.

◆ RowGroups

virtual System.Collections.Generic.IList<DimensionGroup> Google.Apis.Sheets.v4.Data.Sheet.RowGroups
getset

All row groups on this sheet, ordered by increasing range start index, then by group depth.

◆ Slicers

virtual System.Collections.Generic.IList<Slicer> Google.Apis.Sheets.v4.Data.Sheet.Slicers
getset

The slicers on this sheet.


The documentation for this class was generated from the following file: