Class Sheet
A sheet in a spreadsheet.
Implements
Inherited Members
Namespace: Google.Apis.Sheets.v4.Data
Assembly: Google.Apis.Sheets.v4.dll
Syntax
public class Sheet : IDirectResponseSchemaProperties
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> |
Tables
The tables on this sheet.
Declaration
[JsonProperty("tables")]
public virtual IList<Table> Tables { get; set; }Property Value
| Type | Description |
|---|---|
| IList<Table> |