Struct google_sheets4::PivotTable

pub struct PivotTable {
    pub source: Option<GridRange>,
    pub value_layout: Option<String>,
    pub rows: Option<Vec<PivotGroup>>,
    pub values: Option<Vec<PivotValue>>,
    pub criteria: Option<HashMap<String, PivotFilterCriteria>>,
    pub columns: Option<Vec<PivotGroup>>,
}

A pivot table.

This type is not used in any activity, and only used as part of another schema.

Fields

source: Option<GridRange>

The range the pivot table is reading data from.

value_layout: Option<String>

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

rows: Option<Vec<PivotGroup>>

Each row grouping in the pivot table.

values: Option<Vec<PivotValue>>

A list of values to include in the pivot table.

criteria: Option<HashMap<String, PivotFilterCriteria>>

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.

columns: Option<Vec<PivotGroup>>

Each column grouping in the pivot table.

Trait Implementations

impl Clone for PivotTable

fn clone(&self) -> PivotTable

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for PivotTable

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for PivotTable

fn default() -> PivotTable

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for PivotTable

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for PivotTable

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Part for PivotTable