Class PivotTable

Namespace

Shift.Common

Assembly

Shift.Common.dll

public class PivotTable

Inheritance

object

PivotTable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExceptionExtensions.FromHierarchy<TSource>(TSource, Func<TSource, TSource>)

ExceptionExtensions.FromHierarchy<TSource>(TSource, Func<TSource, TSource>, Func<TSource, bool>)

ObjectCopier.CloneJson<T>(T)

ObjectCopier.ShallowCopyTo<TSource, TDestination>(TSource, TDestination, BindingFlags)

Constructors

PivotTable()

public PivotTable()

Properties

CellValueSum

public int CellValueSum { get; }

Property Value

int

ColumnDimensions

public PivotDimensionList ColumnDimensions { get; }

Property Value

PivotDimensionList

Columns

public IPivotDimensionNode Columns { get; }

Property Value

IPivotDimensionNode

IsEmpty

public bool IsEmpty { get; }

Property Value

bool

RowDimensions

public PivotDimensionList RowDimensions { get; }

Property Value

PivotDimensionList

Rows

public IPivotDimensionNode Rows { get; }

Property Value

IPivotDimensionNode

Methods

AddColumn(string)

public void AddColumn(string name)

Parameters

name string

AddColumn(string, string[])

Adds a column dimension to the pivot table.

public void AddColumn(string name, string[] units)

Parameters

name string

units string[]

AddRow(string)

public void AddRow(string name)

Parameters

name string

AddRow(string, string[])

Adds a row dimension to the pivot table.

public void AddRow(string name, string[] units)

Parameters

name string

units string[]

GetCell(MultiKey<string>, MultiKey<string>)

public IPivotCell GetCell(MultiKey<string> row, MultiKey<string> column)

Parameters

row MultiKey<string>

column MultiKey<string>

Returns

IPivotCell

GetCellValue(MultiKey<string>, MultiKey<string>)

Gets the value for the cell indexed by a specific row and column.

public int? GetCellValue(MultiKey<string> row, MultiKey<string> column)

Parameters

row MultiKey<string>

column MultiKey<string>

Returns

int?

GetColumn(MultiKey<string>)

public IPivotDimensionNode GetColumn(MultiKey<string> key)

Parameters

key MultiKey<string>

Returns

IPivotDimensionNode

GetRow(MultiKey<string>)

public IPivotDimensionNode GetRow(MultiKey<string> key)

Parameters

key MultiKey<string>

Returns

IPivotDimensionNode

SetCellValue(MultiKey<string>, MultiKey<string>, int?)

Sets the value for the cell indexed by a specific row and column.

public void SetCellValue(MultiKey<string> row, MultiKey<string> column, int? value)

Parameters

row MultiKey<string>

column MultiKey<string>

value int?

ToHtml(RenderOptions)

Returns the HTML for the pivot table.

public string ToHtml(PivotTable.RenderOptions options = null)

Parameters

options PivotTable.RenderOptions

Returns

string