Struct PivotTable 

pub struct PivotTable {

    pub id: u32,
    pub name: String,
    pub source: String,
    pub anchor: CellRef,
    pub rows: Vec<PivotField>,
    pub columns: Vec<PivotField>,
    pub values: Vec<PivotValue>,
    pub filters: Vec<PivotFilter>,
    pub layout: PivotLayout,
    pub enable_show_details: bool,
    pub grand_totals_rows: bool,
    pub grand_totals_cols: bool,
    pub subtotals: bool,
    pub subtotals_top: bool,
    pub style: String,
    pub show_headers: bool,
    pub last_range: Option<RangeRef>,
    pub calculated_fields: Vec<PivotCalcField>,
    pub values_on_rows: bool,
    pub values_position: Option<usize>,
}

A PivotTable: its definition plus where its output was last written. The output itself is static cell values and styles on the sheet, rewritten on every refresh.

Fields

id: u32

name: String

source: String

Source: range formula text (Sheet1!$A$1:$E$200), a table name or a defined name.

anchor: CellRef

Top-left of the output body on the pivot’s sheet.

rows: Vec<PivotField>

columns: Vec<PivotField>

values: Vec<PivotValue>

filters: Vec<PivotFilter>

layout: PivotLayout

enable_show_details: bool

PivotTable Options › Data › Enable show details: Show Details lists a value cell’s source records only while this is on.

grand_totals_rows: bool

Grand total for each row (the “Grand Total” column), like Excel’s “On for Rows”.

grand_totals_cols: bool

Grand total for each column (the “Grand Total” row), like Excel’s “On for Columns”.

subtotals: bool

subtotals_top: bool

Subtotals at the top of each group (Compact/Outline); otherwise below it.

style: String

show_headers: bool

last_range: Option<RangeRef>

Area written by the last refresh.

calculated_fields: Vec<PivotCalcField>

Calculated fields, usable in the Values area by name.

values_on_rows: bool

The Σ Values pseudo-field (it exists with two or more value fields) sits in Rows rather than Columns (Excel’s “values on rows”).

values_position: Option<usize>

Position of Σ Values among the row fields (None = after the last). Only used with values_on_rows: in Columns Σ Values always comes after the last column field.

Trait Implementations

impl Clone for PivotTable

fn clone(&self) -> PivotTable

Returns a duplicate 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() -> Self

Returns the “default value” for a type.

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

where PivotTable: Default,

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for PivotTable

fn eq(&self, other: &PivotTable) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

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 StructuralPartialEq for PivotTable