| 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 {}
- data FieldSortType
- data PositionedField
- data DataField = DataField {}
- data ConsolidateFunction
Documentation
data PivotTable Source #
Constructors
| PivotTable | |
Fields
| |
Instances
newtype PivotFieldName Source #
Constructors
| PivotFieldName Text |
Instances
| NFData PivotFieldName Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotFieldName -> () Source # | |||||
| Generic PivotFieldName Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Associated Types
Methods from :: PivotFieldName -> Rep PivotFieldName x Source # to :: Rep PivotFieldName x -> PivotFieldName Source # | |||||
| Show PivotFieldName Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable | |||||
| Eq PivotFieldName Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotFieldName -> PivotFieldName -> Bool Source # (/=) :: PivotFieldName -> PivotFieldName -> Bool Source # | |||||
| Ord PivotFieldName Source # | |||||
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 # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods | |||||
| ToAttrVal PivotFieldName Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: PivotFieldName -> Text Source # | |||||
| type Rep PivotFieldName Source # | |||||
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 | |
Instances
| NFData PivotFieldInfo Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PivotFieldInfo -> () Source # | |||||
| Generic PivotFieldInfo Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Associated Types
Methods from :: PivotFieldInfo -> Rep PivotFieldInfo x Source # to :: Rep PivotFieldInfo x -> PivotFieldInfo Source # | |||||
| Show PivotFieldInfo Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable | |||||
| Eq PivotFieldInfo Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PivotFieldInfo -> PivotFieldInfo -> Bool Source # (/=) :: PivotFieldInfo -> PivotFieldInfo -> Bool Source # | |||||
| type Rep PivotFieldInfo Source # | |||||
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
| NFData FieldSortType Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: FieldSortType -> () Source # | |||||
| Generic FieldSortType Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Associated Types
Methods from :: FieldSortType -> Rep FieldSortType x Source # to :: Rep FieldSortType x -> FieldSortType Source # | |||||
| Show FieldSortType Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable | |||||
| Eq FieldSortType Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: FieldSortType -> FieldSortType -> Bool Source # (/=) :: FieldSortType -> FieldSortType -> Bool Source # | |||||
| Ord FieldSortType Source # | |||||
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 # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods | |||||
| ToAttrVal FieldSortType Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: FieldSortType -> Text Source # | |||||
| type Rep FieldSortType Source # | |||||
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
| NFData PositionedField Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: PositionedField -> () Source # | |||||
| Generic PositionedField Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Associated Types
Methods from :: PositionedField -> Rep PositionedField x Source # to :: Rep PositionedField x -> PositionedField Source # | |||||
| Show PositionedField Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable | |||||
| Eq PositionedField Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: PositionedField -> PositionedField -> Bool Source # (/=) :: PositionedField -> PositionedField -> Bool Source # | |||||
| Ord PositionedField Source # | |||||
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 # | |||||
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))) | |||||
Constructors
| DataField | |
Fields | |
Instances
| NFData DataField Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable | |||||
| Generic DataField Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Associated Types
| |||||
| Show DataField Source # | |||||
| Eq DataField Source # | |||||
| type Rep DataField Source # | |||||
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
| NFData ConsolidateFunction Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods rnf :: ConsolidateFunction -> () Source # | |||||
| Generic ConsolidateFunction Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Associated Types
Methods from :: ConsolidateFunction -> Rep ConsolidateFunction x Source # to :: Rep ConsolidateFunction x -> ConsolidateFunction Source # | |||||
| Show ConsolidateFunction Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable | |||||
| Eq ConsolidateFunction Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods (==) :: ConsolidateFunction -> ConsolidateFunction -> Bool Source # (/=) :: ConsolidateFunction -> ConsolidateFunction -> Bool Source # | |||||
| FromAttrVal ConsolidateFunction Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods | |||||
| ToAttrVal ConsolidateFunction Source # | |||||
Defined in Codec.Xlsx.Types.PivotTable Methods toAttrVal :: ConsolidateFunction -> Text Source # | |||||
| type Rep ConsolidateFunction Source # | |||||
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))))) | |||||