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

Eq PivotTable Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotTable -> PivotTable -> Bool # (/=) :: PivotTable -> PivotTable -> Bool #
Show PivotTable Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotTable -> ShowS # show :: PivotTable -> String # showList :: [PivotTable] -> ShowS #
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 #
NFData PivotTable Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotTable -> () #
type Rep PivotTable Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep PivotTable = D1 ('MetaData "PivotTable" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

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 #
Show PivotFieldName Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotFieldName -> ShowS # show :: PivotFieldName -> String # showList :: [PivotFieldName] -> ShowS #
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 #
NFData PivotFieldName Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: 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-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

Eq PivotFieldInfo Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotFieldInfo -> PivotFieldInfo -> Bool # (/=) :: PivotFieldInfo -> PivotFieldInfo -> Bool #
Show PivotFieldInfo Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotFieldInfo -> ShowS # show :: PivotFieldInfo -> String # showList :: [PivotFieldInfo] -> ShowS #
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 #
NFData PivotFieldInfo Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotFieldInfo -> () #
type Rep PivotFieldInfo Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep PivotFieldInfo = D1 ('MetaData "PivotFieldInfo" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

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 #
Show FieldSortType Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> FieldSortType -> ShowS # show :: FieldSortType -> String # showList :: [FieldSortType] -> ShowS #
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 #
NFData FieldSortType Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: 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-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

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 #
Show PositionedField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PositionedField -> ShowS # show :: PositionedField -> String # showList :: [PositionedField] -> ShowS #
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 #
NFData PositionedField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PositionedField -> () #
type Rep PositionedField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep PositionedField = D1 ('MetaData "PositionedField" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

Eq DataField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: DataField -> DataField -> Bool # (/=) :: DataField -> DataField -> Bool #
Show DataField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> DataField -> ShowS # show :: DataField -> String # showList :: [DataField] -> ShowS #
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 #
NFData DataField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: DataField -> () #
type Rep DataField Source #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep DataField = D1 ('MetaData "DataField" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

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