Class PivotTable

A pivot table.

Inheritance

object

PivotTable

Implements

IDirectResponseSchema

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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
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. This field is deprecated in favor of filter_specs.

Declaration

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

Property Value

Type	Description
IDictionary<string, PivotFilterCriteria>

DataExecutionStatus

Output only. The data execution status for data source pivot tables.

Declaration

[JsonProperty("dataExecutionStatus")]
public virtual DataExecutionStatus DataExecutionStatus { get; set; }

Property Value

Type	Description
DataExecutionStatus

DataSourceId

The ID of the data source the pivot table is reading data from.

Declaration

[JsonProperty("dataSourceId")]
public virtual string DataSourceId { get; set; }

Property Value

Type	Description
string

ETag

The ETag of the item.

Declaration

public virtual string ETag { get; set; }

Property Value

Type	Description
string

FilterSpecs

The filters applied to the source columns before aggregating data for the pivot table. Both criteria and filter_specs are populated in responses. If both fields are specified in an update request, this field takes precedence.

Declaration

[JsonProperty("filterSpecs")]
public virtual IList<PivotFilterSpec> FilterSpecs { get; set; }

Property Value

Type	Description
IList<PivotFilterSpec>

Rows

Each row grouping in the pivot table.

Declaration

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

Property Value

Type	Description
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
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
IList<PivotValue>

Implements

IDirectResponseSchema