Codec.Xlsx.Types.PivotTable

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

(==) :: PivotTable -> PivotTable -> Bool

(/=) :: PivotTable -> PivotTable -> Bool

Show PivotTable

Defined in Codec.Xlsx.Types.PivotTable

Methods

showsPrec :: Int -> PivotTable -> ShowS

show :: PivotTable -> String

showList :: [PivotTable] -> ShowS

Generic PivotTable

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: PivotTable -> ()

type Rep PivotTable

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotTable = D1 (MetaData "PivotTable" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.1-9MYBy5o3cf0Evj7k0jFyxz" 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

Defined in Codec.Xlsx.Types.PivotTable

Methods

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

(/=) :: PivotFieldName -> PivotFieldName -> Bool

Ord PivotFieldName

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

showsPrec :: Int -> PivotFieldName -> ShowS

show :: PivotFieldName -> String

showList :: [PivotFieldName] -> ShowS

Generic PivotFieldName

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: PivotFieldName -> ()

FromAttrVal PivotFieldName

Defined in Codec.Xlsx.Types.PivotTable

Methods

fromAttrVal :: Reader PivotFieldName

ToAttrVal PivotFieldName

Defined in Codec.Xlsx.Types.PivotTable

Methods

toAttrVal :: PivotFieldName -> Text

type Rep PivotFieldName

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotFieldName = D1 (MetaData "PivotFieldName" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.1-9MYBy5o3cf0Evj7k0jFyxz" 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

Defined in Codec.Xlsx.Types.PivotTable

Methods

(==) :: PivotFieldInfo -> PivotFieldInfo -> Bool

(/=) :: PivotFieldInfo -> PivotFieldInfo -> Bool

Show PivotFieldInfo

Defined in Codec.Xlsx.Types.PivotTable

Methods

showsPrec :: Int -> PivotFieldInfo -> ShowS

show :: PivotFieldInfo -> String

showList :: [PivotFieldInfo] -> ShowS

Generic PivotFieldInfo

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: PivotFieldInfo -> ()

type Rep PivotFieldInfo

Defined in Codec.Xlsx.Types.PivotTable

type Rep PivotFieldInfo = D1 (MetaData "PivotFieldInfo" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.1-9MYBy5o3cf0Evj7k0jFyxz" 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

Defined in Codec.Xlsx.Types.PivotTable

Methods

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

(/=) :: FieldSortType -> FieldSortType -> Bool

Ord FieldSortType

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

showsPrec :: Int -> FieldSortType -> ShowS

show :: FieldSortType -> String

showList :: [FieldSortType] -> ShowS

Generic FieldSortType

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: FieldSortType -> ()

FromAttrVal FieldSortType

Defined in Codec.Xlsx.Types.PivotTable

Methods

fromAttrVal :: Reader FieldSortType

ToAttrVal FieldSortType

Defined in Codec.Xlsx.Types.PivotTable

Methods

toAttrVal :: FieldSortType -> Text

type Rep FieldSortType

Defined in Codec.Xlsx.Types.PivotTable

type Rep FieldSortType = D1 (MetaData "FieldSortType" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.1-9MYBy5o3cf0Evj7k0jFyxz" 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

Constructors

DataPosition

FieldPosition PivotFieldName

Instances

Eq PositionedField

Defined in Codec.Xlsx.Types.PivotTable

Methods

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

(/=) :: PositionedField -> PositionedField -> Bool

Ord PositionedField

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

showsPrec :: Int -> PositionedField -> ShowS

show :: PositionedField -> String

showList :: [PositionedField] -> ShowS

Generic PositionedField

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: PositionedField -> ()

type Rep PositionedField

Defined in Codec.Xlsx.Types.PivotTable

type Rep PositionedField = D1 (MetaData "PositionedField" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.1-9MYBy5o3cf0Evj7k0jFyxz" 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

Constructors

DataField

Fields

• _dfField :: PivotFieldName
• _dfName :: Text
• _dfFunction :: ConsolidateFunction

Instances

Eq DataField

Defined in Codec.Xlsx.Types.PivotTable

Methods

(==) :: DataField -> DataField -> Bool

(/=) :: DataField -> DataField -> Bool

Show DataField

Defined in Codec.Xlsx.Types.PivotTable

Methods

showsPrec :: Int -> DataField -> ShowS

show :: DataField -> String

showList :: [DataField] -> ShowS

Generic DataField

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: DataField -> ()

type Rep DataField

Defined in Codec.Xlsx.Types.PivotTable

type Rep DataField = D1 (MetaData "DataField" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.1-9MYBy5o3cf0Evj7k0jFyxz" 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

Defined in Codec.Xlsx.Types.PivotTable

Methods

(==) :: ConsolidateFunction -> ConsolidateFunction -> Bool

(/=) :: ConsolidateFunction -> ConsolidateFunction -> Bool

Show ConsolidateFunction

Defined in Codec.Xlsx.Types.PivotTable

Methods

showsPrec :: Int -> ConsolidateFunction -> ShowS

show :: ConsolidateFunction -> String

showList :: [ConsolidateFunction] -> ShowS

Generic ConsolidateFunction

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

Defined in Codec.Xlsx.Types.PivotTable

Methods

rnf :: ConsolidateFunction -> ()

FromAttrVal ConsolidateFunction

Defined in Codec.Xlsx.Types.PivotTable

Methods

fromAttrVal :: Reader ConsolidateFunction

ToAttrVal ConsolidateFunction

Defined in Codec.Xlsx.Types.PivotTable

Methods

toAttrVal :: ConsolidateFunction -> Text

type Rep ConsolidateFunction

Defined in Codec.Xlsx.Types.PivotTable

type Rep ConsolidateFunction = D1 (MetaData "ConsolidateFunction" "Codec.Xlsx.Types.PivotTable" "xlsx-0.8.1-9MYBy5o3cf0Evj7k0jFyxz" 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)))))