Enum PivotVerb 

pub enum PivotVerb {
    AddPivotTable {
        sheet: String,
        anchor: String,
        source: String,
        rows: Vec<String>,
        columns: Vec<String>,
        values: Vec<String>,
        filters: Vec<String>,
        value_layout: Option<ValueLayout>,
        show_totals: bool,
    },
    DeletePivotTable {
        sheet: String,
        anchor: String,
    },
}

Which pivot-table mutation to perform.

Variants

AddPivotTable

Write a new pivot table at anchor, refused if one is already there.

Fields

sheet: String

The sheet anchor lives on.

anchor: String

A single-cell A1 reference (no Sheet! prefix — sheet supplies it).

source: String

The pivot’s source range — may carry its own Sheet! prefix (a pivot commonly sources from a different tab than it’s anchored on); falls back to sheet when it doesn’t.

rows: Vec<String>

Raw COLUMN[:asc|desc] flags, parsed once the source range’s width is known.

columns: Vec<String>

Raw COLUMN[:asc|desc] flags.

values: Vec<String>

Raw COLUMN:FUNC flags. At least one required.

filters: Vec<String>

Raw COLUMN:VALUE[,VALUE...] flags.

value_layout: Option<ValueLayout>

--value-layout, if given.

show_totals: bool

false when --no-totals was given; applies to every row and column group alike (Sheets has no per-group flag on the CLI surface here).

DeletePivotTable

Clear the pivot table at anchor, refused if there isn’t one.

Fields

sheet: String

The sheet anchor lives on.

anchor: String

A single-cell A1 reference (no Sheet! prefix — sheet supplies it).

Trait Implementations

impl Clone for PivotVerb

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PivotVerb

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

Formats the value using the given formatter.

impl Eq for PivotVerb

impl PartialEq for PivotVerb

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

Equality operator ==.

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

Inequality operator !=.

impl StructuralPartialEq for PivotVerb