| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Codec.Xlsx.Types.PivotTable
- 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 |
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 |
data PositionedField Source #
Constructors
| DataPosition | |
| FieldPosition PivotFieldName |
Constructors
| DataField | |
Fields | |
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. |