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

Codec.Xlsx.Types.PivotTable

# Documentation

Constructors

 PivotTable Fields

Instances

 Source # Methods Source # MethodsshowList :: [PivotTable] -> ShowS #

newtype PivotFieldName Source #

Constructors

 PivotFieldName Text

Instances

 Source # Methods Source # Methods Source # MethodsshowList :: [PivotFieldName] -> ShowS # Source # Methods Source # Methods

Constructors

 PivotFieldInfo Fields

Instances

 Source # Methods Source # MethodsshowList :: [PivotFieldInfo] -> ShowS #

Constructors

 DataPosition FieldPosition PivotFieldName

Instances

 Source # Methods Source # Methods Source # MethodsshowList :: [PositionedField] -> ShowS #

data DataField Source #

Constructors

 DataField Fields

Instances

 Source # Methods Source # MethodsshowList :: [DataField] -> ShowS #

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

 Source # Methods Source # Methods Source # Methods Source # Methods