xlsx-1.1.4: Simple and incomplete Excel file parser/writer

Safe Haskell | None
Language | Haskell2010

Codec.Xlsx.Types.PivotTable

Synopsis

- data PivotTable = PivotTable {
  - _pvtName :: Text
  - _pvtDataCaption :: Text
  - _pvtRowFields :: [PositionedField]
  - _pvtColumnFields :: [PositionedField]
  - _pvtDataFields :: [DataField]
  - _pvtFields :: [PivotFieldInfo]
  - _pvtRowGrandTotals :: Bool
  - _pvtColumnGrandTotals :: Bool
  - _pvtOutline :: Bool
  - _pvtOutlineData :: Bool
  - _pvtLocation :: CellRef
  - _pvtSrcSheet :: Text
  - _pvtSrcRef :: Range
  }
- newtype PivotFieldName = PivotFieldName Text
- data PivotFieldInfo = PivotFieldInfo {
  - _pfiName :: Maybe PivotFieldName
  - _pfiOutline :: Bool
  - _pfiSortType :: FieldSortType
  - _pfiHiddenItems :: [CellValue]
  }
- data FieldSortType
  - = FieldSortAscending
  - | FieldSortDescending
  - | FieldSortManual
- data PositionedField
  - = DataPosition
  - | FieldPosition PivotFieldName
- data DataField = DataField {
  - _dfField :: PivotFieldName
  - _dfName :: Text
  - _dfFunction :: ConsolidateFunction
  }
- data ConsolidateFunction
  - = ConsolidateAverage
  - | ConsolidateCount
  - | ConsolidateCountNums
  - | ConsolidateMaximum
  - | ConsolidateMinimum
  - | ConsolidateProduct
  - | ConsolidateStdDev
  - | ConsolidateStdDevP
  - | ConsolidateSum
  - | ConsolidateVariance
  - | ConsolidateVarP

# Documentation

data PivotTable Source #

Constructors

PivotTable |

Fields

- _pvtName :: Text
- _pvtDataCaption :: Text
- _pvtRowFields :: [PositionedField]
- _pvtColumnFields :: [PositionedField]
- _pvtDataFields :: [DataField]
- _pvtFields :: [PivotFieldInfo]
- _pvtRowGrandTotals :: Bool
- _pvtColumnGrandTotals :: Bool
- _pvtOutline :: Bool
- _pvtOutlineData :: Bool
- _pvtLocation :: CellRef
- _pvtSrcSheet :: Text
- _pvtSrcRef :: Range

#### Instances

Instances details

NFData PivotTable Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotTable -> () Source #
Generic PivotTable Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep PivotTable |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotTable = D1 ('MetaData "PivotTable" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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))))))

Methods

from :: PivotTable -> Rep PivotTable x Source #

to :: Rep PivotTable x -> PivotTable Source #

Show PivotTable Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotTable -> ShowS Source # show :: PivotTable -> String Source # showList :: [PivotTable] -> ShowS Source #
Eq PivotTable Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotTable -> PivotTable -> Bool Source # (/=) :: PivotTable -> PivotTable -> Bool Source #
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.4-G0KawmQS4mL8oRGRTaTy8Y" '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

NFData PivotFieldName Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotFieldName -> () Source #
Generic PivotFieldName Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep PivotFieldName |
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep PivotFieldName = D1 ('MetaData "PivotFieldName" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'True) (C1 ('MetaCons "PivotFieldName" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text)))

Methods

from :: PivotFieldName -> Rep PivotFieldName x Source #

to :: Rep PivotFieldName x -> PivotFieldName Source #

Show PivotFieldName Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotFieldName -> ShowS Source # show :: PivotFieldName -> String Source # showList :: [PivotFieldName] -> ShowS Source #
Eq PivotFieldName Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotFieldName -> PivotFieldName -> Bool Source # (/=) :: PivotFieldName -> PivotFieldName -> Bool Source #
Ord PivotFieldName Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

compare :: PivotFieldName -> PivotFieldName -> Ordering Source #

(<) :: PivotFieldName -> PivotFieldName -> Bool Source #

(<=) :: PivotFieldName -> PivotFieldName -> Bool Source #

(>) :: PivotFieldName -> PivotFieldName -> Bool Source #

(>=) :: PivotFieldName -> PivotFieldName -> Bool Source #

max :: PivotFieldName -> PivotFieldName -> PivotFieldName Source #

min :: PivotFieldName -> PivotFieldName -> PivotFieldName Source #

FromAttrVal PivotFieldName Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods fromAttrVal :: Reader PivotFieldName Source #
ToAttrVal PivotFieldName Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: PivotFieldName -> Text Source #
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.4-G0KawmQS4mL8oRGRTaTy8Y" 'True) (C1 ('MetaCons "PivotFieldName" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text)))

data PivotFieldInfo Source #

Constructors

PivotFieldInfo |

Fields

- _pfiName :: Maybe PivotFieldName
- _pfiOutline :: Bool
- _pfiSortType :: FieldSortType
- _pfiHiddenItems :: [CellValue]

#### Instances

Instances details

NFData PivotFieldInfo Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotFieldInfo -> () Source #
Generic PivotFieldInfo Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep PivotFieldInfo |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotFieldInfo = D1 ('MetaData "PivotFieldInfo" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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]))))

Methods

from :: PivotFieldInfo -> Rep PivotFieldInfo x Source #

to :: Rep PivotFieldInfo x -> PivotFieldInfo Source #

Show PivotFieldInfo Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotFieldInfo -> ShowS Source # show :: PivotFieldInfo -> String Source # showList :: [PivotFieldInfo] -> ShowS Source #
Eq PivotFieldInfo Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotFieldInfo -> PivotFieldInfo -> Bool Source # (/=) :: PivotFieldInfo -> PivotFieldInfo -> Bool Source #
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.4-G0KawmQS4mL8oRGRTaTy8Y" '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)

Constructors

FieldSortAscending |
FieldSortDescending |
FieldSortManual |

#### Instances

Instances details

NFData FieldSortType Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: FieldSortType -> () Source #
Generic FieldSortType Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep FieldSortType |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep FieldSortType = D1 ('MetaData "FieldSortType" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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)))

Methods

from :: FieldSortType -> Rep FieldSortType x Source #

to :: Rep FieldSortType x -> FieldSortType Source #

Show FieldSortType Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> FieldSortType -> ShowS Source # show :: FieldSortType -> String Source # showList :: [FieldSortType] -> ShowS Source #
Eq FieldSortType Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: FieldSortType -> FieldSortType -> Bool Source # (/=) :: FieldSortType -> FieldSortType -> Bool Source #
Ord FieldSortType Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

compare :: FieldSortType -> FieldSortType -> Ordering Source #

(<) :: FieldSortType -> FieldSortType -> Bool Source #

(<=) :: FieldSortType -> FieldSortType -> Bool Source #

(>) :: FieldSortType -> FieldSortType -> Bool Source #

(>=) :: FieldSortType -> FieldSortType -> Bool Source #

max :: FieldSortType -> FieldSortType -> FieldSortType Source #

min :: FieldSortType -> FieldSortType -> FieldSortType Source #

FromAttrVal FieldSortType Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods fromAttrVal :: Reader FieldSortType Source #
ToAttrVal FieldSortType Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: FieldSortType -> Text Source #
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.4-G0KawmQS4mL8oRGRTaTy8Y" '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 #

Constructors

DataPosition |
FieldPosition PivotFieldName |

#### Instances

Instances details

NFData PositionedField Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PositionedField -> () Source #
Generic PositionedField Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep PositionedField |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

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

Methods

from :: PositionedField -> Rep PositionedField x Source #

to :: Rep PositionedField x -> PositionedField Source #

Show PositionedField Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PositionedField -> ShowS Source # show :: PositionedField -> String Source # showList :: [PositionedField] -> ShowS Source #
Eq PositionedField Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PositionedField -> PositionedField -> Bool Source # (/=) :: PositionedField -> PositionedField -> Bool Source #
Ord PositionedField Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Methods

compare :: PositionedField -> PositionedField -> Ordering Source #

(<) :: PositionedField -> PositionedField -> Bool Source #

(<=) :: PositionedField -> PositionedField -> Bool Source #

(>) :: PositionedField -> PositionedField -> Bool Source #

(>=) :: PositionedField -> PositionedField -> Bool Source #

max :: PositionedField -> PositionedField -> PositionedField Source #

min :: PositionedField -> PositionedField -> PositionedField Source #

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.4-G0KawmQS4mL8oRGRTaTy8Y" '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 #

Constructors

DataField |

Fields

- _dfField :: PivotFieldName
- _dfName :: Text
- _dfFunction :: ConsolidateFunction

#### Instances

Instances details

NFData DataField Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: DataField -> () Source #
Generic DataField Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep DataField |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep DataField = D1 ('MetaData "DataField" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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))))

Methods

from :: DataField -> Rep DataField x Source #

to :: Rep DataField x -> DataField Source #

Show DataField Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> DataField -> ShowS Source # show :: DataField -> String Source # showList :: [DataField] -> ShowS Source #
Eq DataField Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: DataField -> DataField -> Bool Source # (/=) :: DataField -> DataField -> Bool Source #
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.4-G0KawmQS4mL8oRGRTaTy8Y" '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

NFData ConsolidateFunction Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: ConsolidateFunction -> () Source #
Generic ConsolidateFunction Source # |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

Associated Types

type Rep ConsolidateFunction |

Instance details

Defined in Codec.Xlsx.Types.PivotTable

type Rep ConsolidateFunction = D1 ('MetaData "ConsolidateFunction" "Codec.Xlsx.Types.PivotTable" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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)))))

Methods

from :: ConsolidateFunction -> Rep ConsolidateFunction x Source #

to :: Rep ConsolidateFunction x -> ConsolidateFunction Source #

Show ConsolidateFunction Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> ConsolidateFunction -> ShowS Source # show :: ConsolidateFunction -> String Source # showList :: [ConsolidateFunction] -> ShowS Source #
Eq ConsolidateFunction Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: ConsolidateFunction -> ConsolidateFunction -> Bool Source # (/=) :: ConsolidateFunction -> ConsolidateFunction -> Bool Source #
FromAttrVal ConsolidateFunction Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods fromAttrVal :: Reader ConsolidateFunction Source #
ToAttrVal ConsolidateFunction Source # |
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: ConsolidateFunction -> Text Source #
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.4-G0KawmQS4mL8oRGRTaTy8Y" '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)))))