Safe Haskell	Safe-Inferred
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
data PositionedField
- = DataPosition
- | FieldPosition PivotFieldName
data DataField = DataField {
- _dfField :: PivotFieldName
- _dfName :: Text
- _dfFunction :: ConsolidateFunction
}
data ConsolidateFunction

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

Generic PivotTable Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep PivotTable :: Type -> Type # Methods from :: PivotTable -> Rep PivotTable x # to :: Rep PivotTable x -> PivotTable #
Show PivotTable Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotTable -> ShowS # show :: PivotTable -> String # showList :: [PivotTable] -> ShowS #
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 Methods (==) :: PivotTable -> PivotTable -> Bool # (/=) :: PivotTable -> PivotTable -> Bool #
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 # Methods from :: PivotFieldName -> Rep PivotFieldName x # to :: Rep PivotFieldName x -> PivotFieldName #
Show PivotFieldName Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotFieldName -> ShowS # show :: PivotFieldName -> String # showList :: [PivotFieldName] -> ShowS #
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 Methods (==) :: PivotFieldName -> PivotFieldName -> Bool # (/=) :: PivotFieldName -> PivotFieldName -> Bool #
Ord PivotFieldName Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods compare :: PivotFieldName -> PivotFieldName -> Ordering # (<) :: PivotFieldName -> PivotFieldName -> Bool # (<=) :: PivotFieldName -> PivotFieldName -> Bool # (>) :: PivotFieldName -> PivotFieldName -> Bool # (>=) :: PivotFieldName -> PivotFieldName -> Bool # max :: PivotFieldName -> PivotFieldName -> PivotFieldName # min :: PivotFieldName -> PivotFieldName -> PivotFieldName #
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.0.1-FKUF1Jx3xuq9irRu3xJWCs" '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

Generic PivotFieldInfo Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep PivotFieldInfo :: Type -> Type # Methods from :: PivotFieldInfo -> Rep PivotFieldInfo x # to :: Rep PivotFieldInfo x -> PivotFieldInfo #
Show PivotFieldInfo Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotFieldInfo -> ShowS # show :: PivotFieldInfo -> String # showList :: [PivotFieldInfo] -> ShowS #
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 Methods (==) :: PivotFieldInfo -> PivotFieldInfo -> Bool # (/=) :: PivotFieldInfo -> PivotFieldInfo -> Bool #
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)

Constructors

FieldSortAscending
FieldSortDescending
FieldSortManual

Instances

Instances details

Generic FieldSortType Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep FieldSortType :: Type -> Type # Methods from :: FieldSortType -> Rep FieldSortType x # to :: Rep FieldSortType x -> FieldSortType #
Show FieldSortType Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> FieldSortType -> ShowS # show :: FieldSortType -> String # showList :: [FieldSortType] -> ShowS #
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 Methods (==) :: FieldSortType -> FieldSortType -> Bool # (/=) :: FieldSortType -> FieldSortType -> Bool #
Ord FieldSortType Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods compare :: FieldSortType -> FieldSortType -> Ordering # (<) :: FieldSortType -> FieldSortType -> Bool # (<=) :: FieldSortType -> FieldSortType -> Bool # (>) :: FieldSortType -> FieldSortType -> Bool # (>=) :: FieldSortType -> FieldSortType -> Bool # max :: FieldSortType -> FieldSortType -> FieldSortType # min :: FieldSortType -> FieldSortType -> FieldSortType #
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.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 #

Constructors

DataPosition
FieldPosition PivotFieldName

Instances

Instances details

Generic PositionedField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep PositionedField :: Type -> Type # Methods from :: PositionedField -> Rep PositionedField x # to :: Rep PositionedField x -> PositionedField #
Show PositionedField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PositionedField -> ShowS # show :: PositionedField -> String # showList :: [PositionedField] -> ShowS #
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 Methods (==) :: PositionedField -> PositionedField -> Bool # (/=) :: PositionedField -> PositionedField -> Bool #
Ord PositionedField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods compare :: PositionedField -> PositionedField -> Ordering # (<) :: PositionedField -> PositionedField -> Bool # (<=) :: PositionedField -> PositionedField -> Bool # (>) :: PositionedField -> PositionedField -> Bool # (>=) :: PositionedField -> PositionedField -> Bool # max :: PositionedField -> PositionedField -> PositionedField # min :: PositionedField -> PositionedField -> PositionedField #
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 #

Constructors

DataField
Fields _dfField :: PivotFieldName _dfName :: Text _dfFunction :: ConsolidateFunction

Instances

Instances details

Generic DataField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep DataField :: Type -> Type # Methods from :: DataField -> Rep DataField x # to :: Rep DataField x -> DataField #
Show DataField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> DataField -> ShowS # show :: DataField -> String # showList :: [DataField] -> ShowS #
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 Methods (==) :: DataField -> DataField -> Bool # (/=) :: DataField -> DataField -> Bool #
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 # Methods from :: ConsolidateFunction -> Rep ConsolidateFunction x # to :: Rep ConsolidateFunction x -> ConsolidateFunction #
Show ConsolidateFunction Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> ConsolidateFunction -> ShowS # show :: ConsolidateFunction -> String # showList :: [ConsolidateFunction] -> ShowS #
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 Methods (==) :: ConsolidateFunction -> ConsolidateFunction -> Bool # (/=) :: ConsolidateFunction -> ConsolidateFunction -> Bool #
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.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)))))