Class PivotCellInfo
This class provides an information about a specific cell in a PivotTable.
Inheritance
Namespace: Syncfusion.XlsIO.Implementation.PivotAnalysis
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public class PivotCellInfo : ObjectConstructors
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 ColumnIndexField Value
| Type | Description |
|---|---|
| System.Int32 |
RowIndex
Value indicates the row index of the particular cell value.
Declaration
public int RowIndexField Value
| Type | Description |
|---|---|
| System.Int32 |
Properties
CellRange
Gets or sets any covered range associated with this cell.
Declaration
public CoveredCellRange CellRange { get; set; }Property Value
| Type | Description |
|---|---|
| CoveredCellRange |
CellType
Gets or sets the cell type of this cell.
Declaration
public PivotCellType CellType { get; set; }Property Value
| Type | Description |
|---|---|
| PivotCellType |
DoubleValue
Gets the double value of the cell.
Declaration
public double DoubleValue { get; }Property Value
| Type | Description |
|---|---|
| System.Double |
Format
Gets or sets the format for the cells.
Declaration
public string Format { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
FormattedText
Gets or sets the formatted text displayed in this cell.
Declaration
public string FormattedText { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
Key
Gets or sets the key associated with this cell.
Declaration
public string Key { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
ParentCell
Gets or sets the parent cell.
Declaration
public PivotCellInfo ParentCell { get; set; }Property Value
| Type | Description |
|---|---|
| PivotCellInfo |
RawValues
Gets the RawValues of the particular PivotCellInfo.
Declaration
public List<object> RawValues { get; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.List<System.Object> |
Summary
Gets or sets the summary for the cell.
Declaration
public SummaryBase Summary { get; set; }Property Value
| Type | Description |
|---|---|
| SummaryBase |
Tag
Gets or sets the name of the cell.
Declaration
public object Tag { get; set; }Property Value
| Type | Description |
|---|---|
| System.Object |
UniqueText
Gets or sets the unique text.
Declaration
public string UniqueText { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
Value
Gets or sets the value in the cell.
Declaration
public object Value { get; set; }Property Value
| Type | Description |
|---|---|
| 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 | Description |
|---|---|
| System.String |