xlsx-1.1.0.1: Simple and incomplete Excel file parser/writer
Safe HaskellSafe-Inferred
LanguageHaskell2010

Codec.Xlsx.Types.PivotTable

Synopsis

Documentation

data PivotTable Source #

Instances

Instances details
Generic PivotTable Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep PivotTable :: Type -> Type #

Show PivotTable Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

NFData PivotTable Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: PivotTable -> () #

Eq PivotTable Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotTable Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotTable = D1 ('MetaData "PivotTable" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "PivotTable" 'PrefixI 'True) (((S1 ('MetaSel ('Just "_pvtName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text) :*: (S1 ('MetaSel ('Just "_pvtDataCaption") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text) :*: S1 ('MetaSel ('Just "_pvtRowFields") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [PositionedField]))) :*: (S1 ('MetaSel ('Just "_pvtColumnFields") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [PositionedField]) :*: (S1 ('MetaSel ('Just "_pvtDataFields") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [DataField]) :*: S1 ('MetaSel ('Just "_pvtFields") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [PivotFieldInfo])))) :*: ((S1 ('MetaSel ('Just "_pvtRowGrandTotals") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool) :*: (S1 ('MetaSel ('Just "_pvtColumnGrandTotals") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool) :*: S1 ('MetaSel ('Just "_pvtOutline") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool))) :*: ((S1 ('MetaSel ('Just "_pvtOutlineData") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool) :*: S1 ('MetaSel ('Just "_pvtLocation") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 CellRef)) :*: (S1 ('MetaSel ('Just "_pvtSrcSheet") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text) :*: S1 ('MetaSel ('Just "_pvtSrcRef") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Range))))))

newtype PivotFieldName Source #

Constructors

PivotFieldName Text 

Instances

Instances details
Generic PivotFieldName Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep PivotFieldName :: Type -> Type #

Show PivotFieldName Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

NFData PivotFieldName Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: PivotFieldName -> () #

Eq PivotFieldName Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Ord PivotFieldName Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

FromAttrVal PivotFieldName Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

ToAttrVal PivotFieldName Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotFieldName Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotFieldName = D1 ('MetaData "PivotFieldName" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'True) (C1 ('MetaCons "PivotFieldName" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text)))

data PivotFieldInfo Source #

Instances

Instances details
Generic PivotFieldInfo Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep PivotFieldInfo :: Type -> Type #

Show PivotFieldInfo Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

NFData PivotFieldInfo Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: PivotFieldInfo -> () #

Eq PivotFieldInfo Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotFieldInfo Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotFieldInfo = D1 ('MetaData "PivotFieldInfo" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "PivotFieldInfo" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_pfiName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe PivotFieldName)) :*: S1 ('MetaSel ('Just "_pfiOutline") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool)) :*: (S1 ('MetaSel ('Just "_pfiSortType") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 FieldSortType) :*: S1 ('MetaSel ('Just "_pfiHiddenItems") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [CellValue]))))

data FieldSortType Source #

Sort orders that can be applied to fields in a PivotTable

See 18.18.28 "ST_FieldSortType (Field Sort Type)" (p. 2454)

Instances

Instances details
Generic FieldSortType Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep FieldSortType :: Type -> Type #

Show FieldSortType Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

NFData FieldSortType Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: FieldSortType -> () #

Eq FieldSortType Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Ord FieldSortType Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

FromAttrVal FieldSortType Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

ToAttrVal FieldSortType Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep FieldSortType Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep FieldSortType = D1 ('MetaData "FieldSortType" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "FieldSortAscending" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "FieldSortDescending" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "FieldSortManual" 'PrefixI 'False) (U1 :: Type -> Type)))

data PositionedField Source #

Instances

Instances details
Generic PositionedField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep PositionedField :: Type -> Type #

Show PositionedField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

NFData PositionedField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: PositionedField -> () #

Eq PositionedField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Ord PositionedField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PositionedField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PositionedField = D1 ('MetaData "PositionedField" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "DataPosition" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "FieldPosition" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 PivotFieldName)))

data DataField Source #

Instances

Instances details
Generic DataField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep DataField :: Type -> Type #

Show DataField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

NFData DataField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: DataField -> () #

Eq DataField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep DataField Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep DataField = D1 ('MetaData "DataField" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (C1 ('MetaCons "DataField" 'PrefixI 'True) (S1 ('MetaSel ('Just "_dfField") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 PivotFieldName) :*: (S1 ('MetaSel ('Just "_dfName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text) :*: S1 ('MetaSel ('Just "_dfFunction") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ConsolidateFunction))))

data ConsolidateFunction Source #

Data consolidation functions specified by the user and used to consolidate ranges of data

See 18.18.17 "ST_DataConsolidateFunction (Data Consolidation Functions)" (p. 2447)

Constructors

ConsolidateAverage

The average of the values.

ConsolidateCount

The number of data values. The Count consolidation function works the same as the COUNTA worksheet function.

ConsolidateCountNums

The number of data values that are numbers. The Count Nums consolidation function works the same as the COUNT worksheet function.

ConsolidateMaximum

The largest value.

ConsolidateMinimum

The smallest value.

ConsolidateProduct

The product of the values.

ConsolidateStdDev

An estimate of the standard deviation of a population, where the sample is a subset of the entire population.

ConsolidateStdDevP

The standard deviation of a population, where the population is all of the data to be summarized.

ConsolidateSum

The sum of the values.

ConsolidateVariance

An estimate of the variance of a population, where the sample is a subset of the entire population.

ConsolidateVarP

The variance of a population, where the population is all of the data to be summarized.

Instances

Instances details
Generic ConsolidateFunction Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep ConsolidateFunction :: Type -> Type #

Show ConsolidateFunction Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

NFData ConsolidateFunction Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: ConsolidateFunction -> () #

Eq ConsolidateFunction Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

FromAttrVal ConsolidateFunction Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

ToAttrVal ConsolidateFunction Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep ConsolidateFunction Source # 
Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep ConsolidateFunction = D1 ('MetaData "ConsolidateFunction" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.0.1-FKUF1Jx3xuq9irRu3xJWCs" 'False) (((C1 ('MetaCons "ConsolidateAverage" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "ConsolidateCount" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "ConsolidateCountNums" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "ConsolidateMaximum" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "ConsolidateMinimum" 'PrefixI 'False) (U1 :: Type -> Type)))) :+: ((C1 ('MetaCons "ConsolidateProduct" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "ConsolidateStdDev" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "ConsolidateStdDevP" 'PrefixI 'False) (U1 :: Type -> Type))) :+: (C1 ('MetaCons "ConsolidateSum" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "ConsolidateVariance" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "ConsolidateVarP" 'PrefixI 'False) (U1 :: Type -> Type)))))