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 #

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

Eq PivotTable #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotTable -> PivotTable -> Bool # (/=) :: PivotTable -> PivotTable -> Bool #
Show PivotTable #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotTable -> ShowS # show :: PivotTable -> String # showList :: [PivotTable] -> ShowS #
Generic PivotTable #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep PivotTable :: * -> * # Methods from :: PivotTable -> Rep PivotTable x # to :: Rep PivotTable x -> PivotTable #
NFData PivotTable #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotTable -> () #
type Rep PivotTable #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep PivotTable = D1 (MetaData "PivotTable" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" 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 #

Constructors

PivotFieldName Text

Instances

Eq PivotFieldName #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotFieldName -> PivotFieldName -> Bool # (/=) :: PivotFieldName -> PivotFieldName -> Bool #
Ord PivotFieldName #
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 #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotFieldName -> ShowS # show :: PivotFieldName -> String # showList :: [PivotFieldName] -> ShowS #
Generic PivotFieldName #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep PivotFieldName :: * -> * # Methods from :: PivotFieldName -> Rep PivotFieldName x # to :: Rep PivotFieldName x -> PivotFieldName #
NFData PivotFieldName #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotFieldName -> () #
FromAttrVal PivotFieldName #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods fromAttrVal :: Reader PivotFieldName #
ToAttrVal PivotFieldName #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: PivotFieldName -> Text #
type Rep PivotFieldName #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep PivotFieldName = D1 (MetaData "PivotFieldName" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" True) (C1 (MetaCons "PivotFieldName" PrefixI False) (S1 (MetaSel (Nothing :: Maybe Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text)))

data PivotFieldInfo #

Constructors

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

Instances

Eq PivotFieldInfo #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotFieldInfo -> PivotFieldInfo -> Bool # (/=) :: PivotFieldInfo -> PivotFieldInfo -> Bool #
Show PivotFieldInfo #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PivotFieldInfo -> ShowS # show :: PivotFieldInfo -> String # showList :: [PivotFieldInfo] -> ShowS #
Generic PivotFieldInfo #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep PivotFieldInfo :: * -> * # Methods from :: PivotFieldInfo -> Rep PivotFieldInfo x # to :: Rep PivotFieldInfo x -> PivotFieldInfo #
NFData PivotFieldInfo #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotFieldInfo -> () #
type Rep PivotFieldInfo #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep PivotFieldInfo = D1 (MetaData "PivotFieldInfo" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" 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 #

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

Eq FieldSortType #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: FieldSortType -> FieldSortType -> Bool # (/=) :: FieldSortType -> FieldSortType -> Bool #
Ord FieldSortType #
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 #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> FieldSortType -> ShowS # show :: FieldSortType -> String # showList :: [FieldSortType] -> ShowS #
Generic FieldSortType #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep FieldSortType :: * -> * # Methods from :: FieldSortType -> Rep FieldSortType x # to :: Rep FieldSortType x -> FieldSortType #
NFData FieldSortType #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: FieldSortType -> () #
FromAttrVal FieldSortType #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods fromAttrVal :: Reader FieldSortType #
ToAttrVal FieldSortType #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: FieldSortType -> Text #
type Rep FieldSortType #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep FieldSortType = D1 (MetaData "FieldSortType" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" False) (C1 (MetaCons "FieldSortAscending" PrefixI False) (U1 :: * -> ) :+: (C1 (MetaCons "FieldSortDescending" PrefixI False) (U1 :: -> ) :+: C1 (MetaCons "FieldSortManual" PrefixI False) (U1 :: -> *)))

data PositionedField #

Constructors

DataPosition
FieldPosition PivotFieldName

Instances

Eq PositionedField #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PositionedField -> PositionedField -> Bool # (/=) :: PositionedField -> PositionedField -> Bool #
Ord PositionedField #
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 #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> PositionedField -> ShowS # show :: PositionedField -> String # showList :: [PositionedField] -> ShowS #
Generic PositionedField #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep PositionedField :: * -> * # Methods from :: PositionedField -> Rep PositionedField x # to :: Rep PositionedField x -> PositionedField #
NFData PositionedField #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PositionedField -> () #
type Rep PositionedField #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep PositionedField = D1 (MetaData "PositionedField" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" False) (C1 (MetaCons "DataPosition" PrefixI False) (U1 :: * -> *) :+: C1 (MetaCons "FieldPosition" PrefixI False) (S1 (MetaSel (Nothing :: Maybe Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 PivotFieldName)))

data DataField #

Constructors

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

Instances

Eq DataField #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: DataField -> DataField -> Bool # (/=) :: DataField -> DataField -> Bool #
Show DataField #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> DataField -> ShowS # show :: DataField -> String # showList :: [DataField] -> ShowS #
Generic DataField #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep DataField :: * -> * # Methods from :: DataField -> Rep DataField x # to :: Rep DataField x -> DataField #
NFData DataField #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: DataField -> () #
type Rep DataField #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep DataField = D1 (MetaData "DataField" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" 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 #

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

Eq ConsolidateFunction #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: ConsolidateFunction -> ConsolidateFunction -> Bool # (/=) :: ConsolidateFunction -> ConsolidateFunction -> Bool #
Show ConsolidateFunction #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods showsPrec :: Int -> ConsolidateFunction -> ShowS # show :: ConsolidateFunction -> String # showList :: [ConsolidateFunction] -> ShowS #
Generic ConsolidateFunction #
Instance details Defined in Codec.Xlsx.Types.PivotTable Associated Types type Rep ConsolidateFunction :: * -> * # Methods from :: ConsolidateFunction -> Rep ConsolidateFunction x # to :: Rep ConsolidateFunction x -> ConsolidateFunction #
NFData ConsolidateFunction #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: ConsolidateFunction -> () #
FromAttrVal ConsolidateFunction #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods fromAttrVal :: Reader ConsolidateFunction #
ToAttrVal ConsolidateFunction #
Instance details Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: ConsolidateFunction -> Text #
type Rep ConsolidateFunction #
Instance details Defined in Codec.Xlsx.Types.PivotTable type Rep ConsolidateFunction = D1 (MetaData "ConsolidateFunction" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-LJxbVm4yJQxBp0QchhVN6B" False) (((C1 (MetaCons "ConsolidateAverage" PrefixI False) (U1 :: * -> ) :+: C1 (MetaCons "ConsolidateCount" PrefixI False) (U1 :: -> )) :+: (C1 (MetaCons "ConsolidateCountNums" PrefixI False) (U1 :: -> ) :+: (C1 (MetaCons "ConsolidateMaximum" PrefixI False) (U1 :: -> ) :+: C1 (MetaCons "ConsolidateMinimum" PrefixI False) (U1 :: -> )))) :+: ((C1 (MetaCons "ConsolidateProduct" PrefixI False) (U1 :: -> ) :+: (C1 (MetaCons "ConsolidateStdDev" PrefixI False) (U1 :: -> ) :+: C1 (MetaCons "ConsolidateStdDevP" PrefixI False) (U1 :: -> ))) :+: (C1 (MetaCons "ConsolidateSum" PrefixI False) (U1 :: -> ) :+: (C1 (MetaCons "ConsolidateVariance" PrefixI False) (U1 :: -> ) :+: C1 (MetaCons "ConsolidateVarP" PrefixI False) (U1 :: -> *)))))