HeatmapPivotTable Class

NReco.PivotData Class Library Documentation
Pivot table wrapper that highlights max values.
Inheritance Hierarchy
SystemObject
  NReco.PivotDataHeatmapPivotTable

Namespace:  NReco.PivotData
Assembly:  NReco.PivotData.Extensions (in NReco.PivotData.Extensions.dll) Version: 1.6.1
Syntax
Copy
public class HeatmapPivotTable : IPivotTable

The HeatmapPivotTable type exposes the following members.

Constructors
  NameDescription
Public methodHeatmapPivotTable(IPivotTable, HeatmapPivotTableHeatmapMode)
Initializes a new instance of HeatmapPivotTable instance by specified IPivotTable and heatmap mode.
Public methodHeatmapPivotTable(IPivotTable, HeatmapPivotTableHeatmapMode, Int32)
Initializes a new instance of HeatmapPivotTable instance by specified IPivotTable, heatmap mode and measure index.
Top
Properties
  NameDescription
Public propertyBaseColor
Base color used to highlight max or min values.
Public propertyColumnKeys
Public propertyColumns
Public propertyMode
Heatmap max value calculation mode.
Public propertyPivotData
Public propertyRowKeys
Public propertyRows
Top
Methods
  NameDescription
Protected methodCompare
Compares 2 pivot table values to determine max and min.
Public methodEquals (Inherited from Object.)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodGetValue
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToString (Inherited from Object.)
Top
Remarks
Use this class to heat map for a pivot table that is rendered with PivotTableHtmlWriter or PivotTableExcelWriter. It is possible to specify which measure should be highlighted if pivot table has several measures.
Examples
Copy
PivotTable originalPvtTbl;
var heatmapPvtTbl = new HeatmapPivotTable(originalPvtTbl, HeatmapPivotTable.HeatmapMode.Table);
var heatmapPvtTbl.BaseColor = 0xFF0000; // red is used by default
See Also

Reference

NReco.PivotData Namespace