xlsx-0.7.2: Simple and incomplete Excel file parser/writer

Safe HaskellNone
LanguageHaskell2010

Codec.Xlsx.Types.PivotTable

Synopsis

Documentation

data PivotTable #

Instances

Eq PivotTable # 
Show PivotTable # 
Generic PivotTable # 

Associated Types

type Rep PivotTable :: * -> * #

NFData PivotTable # 

Methods

rnf :: PivotTable -> () #

type Rep PivotTable # 
type Rep PivotTable = D1 * (MetaData "PivotTable" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" False) (C1 * (MetaCons "PivotTable" PrefixI True) ((:*:) * ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_pvtName") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Text)) ((:*:) * (S1 * (MetaSel (Just Symbol "_pvtDataCaption") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Text)) (S1 * (MetaSel (Just Symbol "_pvtRowFields") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [PositionedField])))) ((:*:) * (S1 * (MetaSel (Just Symbol "_pvtColumnFields") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [PositionedField])) ((:*:) * (S1 * (MetaSel (Just Symbol "_pvtDataFields") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [DataField])) (S1 * (MetaSel (Just Symbol "_pvtFields") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [PivotFieldInfo]))))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_pvtRowGrandTotals") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)) ((:*:) * (S1 * (MetaSel (Just Symbol "_pvtColumnGrandTotals") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)) (S1 * (MetaSel (Just Symbol "_pvtOutline") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_pvtOutlineData") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)) (S1 * (MetaSel (Just Symbol "_pvtLocation") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * CellRef))) ((:*:) * (S1 * (MetaSel (Just Symbol "_pvtSrcSheet") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Text)) (S1 * (MetaSel (Just Symbol "_pvtSrcRef") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Range)))))))

data FieldSortType #

Sort orders that can be applied to fields in a PivotTable

See 18.18.28 "ST_FieldSortType (Field Sort Type)" (p. 2454)

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 # 
Show ConsolidateFunction # 
Generic ConsolidateFunction # 
NFData ConsolidateFunction # 

Methods

rnf :: ConsolidateFunction -> () #

FromAttrVal ConsolidateFunction # 
ToAttrVal ConsolidateFunction # 
type Rep ConsolidateFunction # 
type Rep ConsolidateFunction = D1 * (MetaData "ConsolidateFunction" "Codec.Xlsx.Types.PivotTable" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" 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 *))))))