Class PivotTable

A pivot table.

Inheritance

System.Object

PivotTable

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 PivotTable : IDirectResponseSchema

Properties

Columns

Each column grouping in the pivot table.

Declaration

[JsonProperty("columns")]
public virtual IList<PivotGroup> Columns { get; set; }

Property Value

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

Criteria

An optional mapping of filters per source column offset.

The filters are applied before aggregating data into the pivot table. The map's key is the column offset of the source range that you want to filter, and the value is the criteria for that column.

For example, if the source was C10:E15, a key of 0 will have the filter for column C, whereas the key 1 is for column D.

Declaration

[JsonProperty("criteria")]
public virtual IDictionary<string, PivotFilterCriteria> Criteria { get; set; }

Property Value

Type	Description
System.Collections.Generic.IDictionary<System.String, PivotFilterCriteria>

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
System.String

Rows

Each row grouping in the pivot table.

Declaration

[JsonProperty("rows")]
public virtual IList<PivotGroup> Rows { get; set; }

Property Value

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

Source

The range the pivot table is reading data from.

Declaration

[JsonProperty("source")]
public virtual GridRange Source { get; set; }

Property Value

Type	Description
GridRange

ValueLayout

Whether values should be listed horizontally (as columns) or vertically (as rows).

Declaration

[JsonProperty("valueLayout")]
public virtual string ValueLayout { get; set; }

Property Value

Type	Description
System.String

Values

A list of values to include in the pivot table.

Declaration

[JsonProperty("values")]
public virtual IList<PivotValue> Values { get; set; }

Property Value

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

Implements

Google.Apis.Requests.IDirectResponseSchema