PivotTableExcelWriter Class

NReco.PivotData Class Library Documentation
Renders pivot table report into Excel format (XLSX).
Inheritance Hierarchy

SystemObject
  NReco.PivotData.OutputPivotTableWriterBase
    NReco.PivotData.OutputPivotTableExcelWriter

Namespace:  NReco.PivotData.Output
Assembly:  NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.4.2
Syntax

public class PivotTableExcelWriter : PivotTableWriterBase

The PivotTableExcelWriter type exposes the following members.

Constructors

  NameDescription
Public methodPivotTableExcelWriter(ExcelWorksheet)
Initializes a new instance of the PivotTableExcelWriter class
Public methodPivotTableExcelWriter(Stream, String)
Initializes a new instance of the PivotTableExcelWriter class
Top
Properties

  NameDescription
Public propertyFormatDimensionLabel
Gets or sets custom formatting handler for dimension labels.
Public propertyFormatKey
Gets or sets function for formatting dimension key values.
Public propertyFormatMeasureHeader
Gets or sets custom formatting handler for measure headers (applicable only if several measures are used)
Public propertyFormatValue
Gets or sets custom formatting handler for table cell values (measure,measure index)->(value)
Public propertyGrandTotal
Include grand totals value into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.)
Public propertyRepeatDuplicateKeysAcrossDimensions
Repeat duplicate keys across dimensions in one group (repeat for both rows and columns by default).
Public propertyRepeatKeysInGroups
Repeat keys in group of the same dimension (no repeat by default).
Public propertyStartCellColumn
Gets or sets pivot table starting cell column index (default is 1).
Public propertyStartCellRow
Gets or sets pivot table starting cell row index (default is 1).
Public propertySubtotalColumns
Include subtotal columns into resulting pivot table (false by default).
Public propertySubtotalDimensions
Explicit list of dimensions with subtotals (null = generate subtotals for all groups).
Public propertySubtotalKeySuffix
Suffix added to subtotal keys (" Total" by default).
Public propertySubtotalRows
Include subtotal rows into resulting pivot table (false by default).
Public propertyTotalsColumn
Include totals column into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.)
Public propertyTotalsColumnHeaderText
Gets or sets title text for totals column header (Totals by default).
(Inherited from PivotTableWriterBase.)
Public propertyTotalsRow
Include totals row into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.)
Public propertyTotalsRowHeaderText
Gets or sets title text for totals row header (Totals by default).
(Inherited from PivotTableWriterBase.)
Top
Methods

  NameDescription
Protected methodApplyBorderStyles
Protected methodApplyColumnHeaderStyles
Protected methodApplyMeasureHeaderStyles
Protected methodApplyRowHeaderStyles
Protected methodApplyTotalsHeaderStyles
Protected methodApplyValueStyles(ExcelRange, Int32) Obsolete.
Protected methodApplyValueStyles(ExcelRange, IAggregator, Int32)
Protected methodCreateStyles
Defines default named styles ("pvtRow", "pvtColumn").
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Protected methodGetAggregatorsCount (Inherited from PivotTableWriterBase.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Public methodWrite
Renders pivot table into Excel worksheet using data from specified PivotTable instance.
Protected methodWriteReportData
Top
See Also

Reference