Class Sheet

A sheet in a spreadsheet.

Inheritance

System.Object

Sheet

Implements

Google.Apis.Requests.IDirectResponseSchema

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Google.Apis.Sheets.v4.Data

Assembly: Google.Apis.Sheets.v4.dll

Syntax

public class Sheet : IDirectResponseSchema

Properties

BandedRanges

The banded (alternating colors) ranges on this sheet.

Declaration

[JsonProperty("bandedRanges")]
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

[JsonProperty("basicFilter")]
public virtual BasicFilter BasicFilter { get; set; }

Property Value

Type	Description
BasicFilter

Charts

The specifications of every chart on this sheet.

Declaration

[JsonProperty("charts")]
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

[JsonProperty("columnGroups")]
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

[JsonProperty("conditionalFormats")]
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

[JsonProperty("data")]
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

[JsonProperty("developerMetadata")]
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

[JsonProperty("filterViews")]
public virtual IList<FilterView> FilterViews { get; set; }

Property Value

Type	Description
System.Collections.Generic.IList<FilterView>

Merges

The ranges that are merged together.

Declaration

[JsonProperty("merges")]
public virtual IList<GridRange> Merges { get; set; }

Property Value

Type	Description
System.Collections.Generic.IList<GridRange>

Properties

The properties of the sheet.

Declaration

[JsonProperty("properties")]
public virtual SheetProperties Properties { get; set; }

Property Value

Type	Description
SheetProperties

ProtectedRanges

The protected ranges in this sheet.

Declaration

[JsonProperty("protectedRanges")]
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

[JsonProperty("rowGroups")]
public virtual IList<DimensionGroup> RowGroups { get; set; }

Property Value

Type	Description
System.Collections.Generic.IList<DimensionGroup>

Slicers

The slicers on this sheet.

Declaration

[JsonProperty("slicers")]
public virtual IList<Slicer> Slicers { get; set; }

Property Value

Type	Description
System.Collections.Generic.IList<Slicer>

Implements

Google.Apis.Requests.IDirectResponseSchema