Struct AddPivotTableInput 

pub struct AddPivotTableInput {

    pub workbook_id: String,
    pub sheet_name: String,
    pub cell: Option<String>,
    pub name: String,
    pub source_range: String,
    pub row_fields: Vec<String>,
    pub column_fields: Vec<String>,
    pub value_fields: Vec<PivotValueFieldInput>,
    pub filter_fields: Vec<String>,
    pub style: Option<String>,
    pub layout: Option<String>,
    pub calculated_fields: Vec<PivotCalculatedFieldInput>,
    pub date_groups: Vec<PivotDateGroupInput>,
    pub range_groups: Vec<PivotRangeGroupInput>,
    pub value_formats: Vec<PivotValueFormatInput>,
    pub subtotals: Vec<PivotSubtotalToggle>,
    pub grand_total_rows: Option<bool>,
    pub grand_total_cols: Option<bool>,
    pub show_row_headers: Option<bool>,
    pub show_column_headers: Option<bool>,
    pub show_row_stripes: Option<bool>,
}

Input for creating a pivot table

Fields

workbook_id: String

sheet_name: String

cell: Option<String>

Cell where pivot table starts (e.g. “A1”)

name: String

source_range: String

Source range including sheet (e.g. “‘Data’!$A$1:$E$100”)

row_fields: Vec<String>

column_fields: Vec<String>

value_fields: Vec<PivotValueFieldInput>

filter_fields: Vec<String>

style: Option<String>

layout: Option<String>

Layout: compact, outline, tabular. Default: compact

calculated_fields: Vec<PivotCalculatedFieldInput>

Calculated fields to add

date_groups: Vec<PivotDateGroupInput>

Date grouping for fields

range_groups: Vec<PivotRangeGroupInput>

Numeric range grouping for fields

value_formats: Vec<PivotValueFormatInput>

Number format for value fields

subtotals: Vec<PivotSubtotalToggle>

Toggle subtotals per field

grand_total_rows: Option<bool>

Show grand totals for rows

grand_total_cols: Option<bool>

Show grand totals for columns

show_row_headers: Option<bool>

Show row headers

show_column_headers: Option<bool>

Show column headers

show_row_stripes: Option<bool>

Show row stripes

Trait Implementations

impl<'de> Deserialize<'de> for AddPivotTableInput

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl JsonSchema for AddPivotTableInput

fn schema_name() -> Cow<'static, str>

The name of the generated JSON Schema.

fn schema_id() -> Cow<'static, str>

Returns a string that uniquely identifies the schema produced by this type.

fn json_schema(generator: &mut SchemaGenerator) -> Schema

Generates a JSON Schema for this type.

fn inline_schema() -> bool

Whether JSON Schemas generated for this type should be included directly in parent schemas, rather than being re-used where possible using the $ref keyword.