Class Sheet
A sheet in a spreadsheet.
Inheritance
Implements
Namespace: Google.Apis.Sheets.v4.Data
Assembly: Google.Apis.Sheets.v4.dll
Syntax
public class Sheet : object, IDirectResponseSchemaProperties
BandedRanges
The banded (alternating colors) ranges on this sheet.
Declaration
public virtual IList<BandedRange> BandedRanges { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<BandedRange> |
BasicFilter
The filter on this sheet, if any.
Declaration
public virtual BasicFilter BasicFilter { get; set; }Property Value
| Type | Description |
|---|---|
| BasicFilter |
Charts
The specifications of every chart on this sheet.
Declaration
public virtual IList<EmbeddedChart> Charts { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<EmbeddedChart> |
ColumnGroups
All column groups on this sheet, ordered by increasing range start index, then by group depth.
Declaration
public virtual IList<DimensionGroup> ColumnGroups { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<DimensionGroup> |
ConditionalFormats
The conditional format rules in this sheet.
Declaration
public virtual IList<ConditionalFormatRule> ConditionalFormats { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<ConditionalFormatRule> |
Data
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).
Declaration
public virtual IList<GridData> Data { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<GridData> |
DeveloperMetadata
The developer metadata associated with a sheet.
Declaration
public virtual IList<DeveloperMetadata> DeveloperMetadata { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<DeveloperMetadata> |
ETag
The ETag of the item.
Declaration
public virtual string ETag { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
FilterViews
The filter views in this sheet.
Declaration
public virtual IList<FilterView> FilterViews { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<FilterView> |
Merges
The ranges that are merged together.
Declaration
public virtual IList<GridRange> Merges { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<GridRange> |
Properties
The properties of the sheet.
Declaration
public virtual SheetProperties Properties { get; set; }Property Value
| Type | Description |
|---|---|
| SheetProperties |
ProtectedRanges
The protected ranges in this sheet.
Declaration
public virtual IList<ProtectedRange> ProtectedRanges { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<ProtectedRange> |
RowGroups
All row groups on this sheet, ordered by increasing range start index, then by group depth.
Declaration
public virtual IList<DimensionGroup> RowGroups { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<DimensionGroup> |
Slicers
The slicers on this sheet.
Declaration
public virtual IList<Slicer> Slicers { get; set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.IList<Slicer> |