Class PivotCellInfo
This class provides an information about a specific cell in a PivotTable.
Inheritance
Namespace: Syncfusion.XlsIO.Implementation.PivotAnalysis
Assembly: Syncfusion.XlsIO.NET.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 |