Exports pivot table model to ADO.NET DataTable.
Inheritance Hierarchy
NReco.PivotData.OutputPivotTableWriterBase
NReco.PivotData.OutputPivotTableDataTableWriter
Namespace: NReco.PivotData.Output
Assembly: NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.6.1
Syntax
The PivotTableDataTableWriter type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | PivotTableDataTableWriter | Initializes a new instance of the PivotTableDataTableWriter class |
Properties
| Name | Description | |
|---|---|---|
 | ColumnCaptionSeparator |
Gets or sets separator for joining column caption parts.
|
| FormatAggregatorName |
Gets or sets custom formatting handler for aggregator name (aggregator factory)->(label).
|
| FormatColumnKey |
Gets or sets custom formatting handler for table column labels (key,dimension)->(label).
|
| GrandTotal |
Include grand totals value into resulting pivot table (true by default).
(Inherited from PivotTableWriterBase.) |
| SubtotalColumns |
Include subtotal columns into resulting pivot table (false 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 | |
|---|---|---|
| Equals | (Inherited from Object.) |
 | Finalize | (Inherited from Object.) |
| GetAggregatorsCount | (Inherited from PivotTableWriterBase.) |
| GetAggregatorValue | |
| GetHashCode | (Inherited from Object.) |
| GetType | (Inherited from Object.) |
| MemberwiseClone | (Inherited from Object.) |
| ToString | (Inherited from Object.) |
| Write |
Generate DataTable by specified PivotTable instance.
|
Remarks
Examples
PivotTable pvtTbl; // lets assume we already have a PivotTable instance var pvtDataTableWr = new PivotTableDataTableWriter("PivotTable"); DataTable res = pvtDataTableWr.Write(pvtTbl);
See Also