Class Sheet

A sheet in a spreadsheet.

Inheritance
object
Sheet
Implements
Inherited Members
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
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
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
IList<DimensionGroup>

ConditionalFormats

The conditional format rules in this sheet.

Declaration
[JsonProperty("conditionalFormats")]
public virtual IList<ConditionalFormatRule> ConditionalFormats { get; set; }
Property Value
Type Description
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). For a DATA_SOURCE sheet, you can not request a specific range, the GridData contains all the values.

Declaration
[JsonProperty("data")]
public virtual IList<GridData> Data { get; set; }
Property Value
Type Description
IList<GridData>

DeveloperMetadata

The developer metadata associated with a sheet.

Declaration
[JsonProperty("developerMetadata")]
public virtual IList<DeveloperMetadata> DeveloperMetadata { get; set; }
Property Value
Type Description
IList<DeveloperMetadata>

ETag

The ETag of the item.

Declaration
public virtual string ETag { get; set; }
Property Value
Type Description
string

FilterViews

The filter views in this sheet.

Declaration
[JsonProperty("filterViews")]
public virtual IList<FilterView> FilterViews { get; set; }
Property Value
Type Description
IList<FilterView>

Merges

The ranges that are merged together.

Declaration
[JsonProperty("merges")]
public virtual IList<GridRange> Merges { get; set; }
Property Value
Type Description
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
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
IList<DimensionGroup>

Slicers

The slicers on this sheet.

Declaration
[JsonProperty("slicers")]
public virtual IList<Slicer> Slicers { get; set; }
Property Value
Type Description
IList<Slicer>

Implements