Renders pivot table report into Excel format (XLSX).
Inheritance Hierarchy
NReco.PivotData.Output.PivotTableWriterBase
NReco.PivotData.Output.PivotTableExcelWriter
Namespace: NReco.PivotData.Output
Assembly: NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.6.1
Syntax
The PivotTableExcelWriter type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | PivotTableExcelWriter(ExcelWorksheet) | Initializes a new instance of the PivotTableExcelWriter class |
| PivotTableExcelWriter(Stream, String) | Initializes a new instance of the PivotTableExcelWriter class |
Properties
| Name | Description | |
|---|---|---|
 | FormatDimensionLabel |
Gets or sets custom formatting handler for dimension labels.
|
| FormatKey |
Gets or sets function for formatting dimension key values.
|
| FormatMeasureHeader |
Gets or sets custom formatting handler for measure headers (applicable only if several measures are used)
|
| FormatValue |
Gets or sets custom formatting handler for table cell values (measure,measure index)->(value)
|
| GrandTotal |
Include grand totals value into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.) |
| RepeatDuplicateKeysAcrossDimensions |
Repeat duplicate keys across dimensions in one group (repeat for both rows and columns by default).
|
| RepeatKeysInGroups |
Repeat keys in group of the same dimension (no repeat by default).
|
| StartCellColumn |
Gets or sets pivot table starting cell column index (default is 1).
|
| StartCellRow |
Gets or sets pivot table starting cell row index (default is 1).
|
| SubtotalColumns |
Include subtotal columns into resulting pivot table (false by default).
|
| SubtotalDimensions |
Explicit list of dimensions with subtotals (null = generate subtotals for all groups).
|
| SubtotalKeySuffix |
Suffix added to subtotal keys (" Total" by default).
|
| SubtotalRows |
Include subtotal rows into resulting pivot table (false by default).
|
| TotalsColumn |
Include totals column into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.) |
| TotalsColumnHeaderText |
Gets or sets title text for totals column header (Totals by default).
(Inherited from PivotTableWriterBase.) |
| TotalsColumnPosition |
Determins totals column position (first column or last column).
(Inherited from PivotTableWriterBase.) |
| TotalsRow |
Include totals row into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.) |
| TotalsRowHeaderText |
Gets or sets title text for totals row header (Totals by default).
(Inherited from PivotTableWriterBase.) |
| TotalsRowPosition |
Determins totals row position (first row or last row).
(Inherited from PivotTableWriterBase.) |
Methods
| Name | Description | |
|---|---|---|
 | ApplyBorderStyles | |
| ApplyColumnHeaderStyles |
Override this method to apply common styles for column headers.
|
| ApplyDimensionKeyStyles |
Override this method to apply styles that are specific to the dimension keys.
|
| ApplyMeasureHeaderStyles | |
| ApplyRowHeaderStyles |
Override this method to apply common styles for row headers.
|
| ApplyTotalsHeaderStyles | |
| ApplyValueStyles(ExcelRange, Int32) | Obsolete. |
| ApplyValueStyles(ExcelRange, IAggregator, Int32) | |
| AutoFitColumns | |
| CreateStyles |
Defines default named styles ("pvtRow", "pvtColumn").
|
| Equals | (Inherited from Object.) |
| Finalize | (Inherited from Object.) |
| GetAggregatorsCount | (Inherited from PivotTableWriterBase.) |
| GetHashCode | (Inherited from Object.) |
| GetType | (Inherited from Object.) |
| MemberwiseClone | (Inherited from Object.) |
| ToString | (Inherited from Object.) |
| Write |
Renders pivot table into Excel worksheet using data from specified PivotTable instance.
|
| WriteReportData |
See Also