Class PivotCellInfo

This class provides an information about a specific cell in a PivotTable.

Inheritance

System.Object

PivotCellInfo

Namespace: Syncfusion.XlsIO.Implementation.PivotAnalysis

Assembly: Syncfusion.XlsIO.Portable.dll

Syntax

public class PivotCellInfo : Object

Constructors

PivotCellInfo()

Initializes a new instance of the PivotCellInfo class.

Declaration

public PivotCellInfo()

Fields

ColumnIndex

Value indicates the column index of the particular cell value.

Declaration

public int ColumnIndex

Field Value

Type
System.Int32

RowIndex

Value indicates the row index of the particular cell value.

Declaration

public int RowIndex

Field Value

Type
System.Int32

Properties

CellRange

Gets or sets any covered range associated with this cell.

Declaration

public CoveredCellRange CellRange { get; set; }

Property Value

Type
CoveredCellRange

CellType

Gets or sets the cell type of this cell.

Declaration

public PivotCellType CellType { get; set; }

Property Value

Type
PivotCellType

DoubleValue

Gets the double value of the cell.

Declaration

public double DoubleValue { get; }

Property Value

Type
System.Double

Format

Gets or sets the format for the cells.

Declaration

public string Format { get; set; }

Property Value

Type
System.String

FormattedText

Gets or sets the formatted text displayed in this cell.

Declaration

public string FormattedText { get; set; }

Property Value

Type
System.String

Key

Gets or sets the key associated with this cell.

Declaration

public string Key { get; set; }

Property Value

Type
System.String

ParentCell

Gets or sets the parent cell.

Declaration

public PivotCellInfo ParentCell { get; set; }

Property Value

Type
PivotCellInfo

RawValues

Gets the RawValues of the particular PivotCellInfo.

Declaration

public List<object> RawValues { get; }

Property Value

Type
System.Collections.Generic.List<System.Object>

Summary

Gets or sets the summary for the cell.

Declaration

public SummaryBase Summary { get; set; }

Property Value

Type
SummaryBase

Tag

Gets or sets the name of the cell.

Declaration

public object Tag { get; set; }

Property Value

Type
System.Object

UniqueText

Gets or sets the unique text.

Declaration

public string UniqueText { get; set; }

Property Value

Type
System.String

Value

Gets or sets the value in the cell.

Declaration

public object Value { get; set; }

Property Value

Type
System.Object

Methods

Dispose()

Method to dispose the pivot cell information

Declaration

public void Dispose()

ToString()

Returns the formatted text.

Declaration

public override string ToString()

Returns

Type
System.String