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.4.2
Syntax

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

PivotTable originalPvtTbl;
var heatmapPvtTbl = new HeatmapPivotTable(originalPvtTbl, HeatmapPivotTable.HeatmapMode.Table);
var heatmapPvtTbl.BaseColor = 0xFF0000; // red is used by default
See Also

Reference