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>,
}

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

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.