Spire.XLS API

XlsPivotCacheField Class

Represents a field in a pivot cache, which is used in Excel to store and organize data for pivot tables.

Inheritance Hierarchy

System Object
Spire.Xls.Core.Spreadsheet.PivotTables XlsPivotCacheField

Namespace: Spire.Xls.Core.Spreadsheet.PivotTables
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public class XlsPivotCacheField

Public Class XlsPivotCacheField

public ref class XlsPivotCacheField

type XlsPivotCacheField =class end

The XlsPivotCacheField type exposes the following members.

Properties

	Name	Description
	Caption	Specifies the caption of the cache field
	DataType	Gets type of the data.
	Formula	Specifies the formula for the calculated field
	Index	Gets/sets item's index in the parent collection.
	IsDataBaseField	Specifies a boolean value that indicates whether this field came from the source database
	IsDate	Gets a value indicating whether the cache field is set to handle only dates.
	IsDouble	Gets or sets a value indicating whether the cache field contains a double.
	IsDoubleInt	Gets or sets a value indicating whether the cache field contains an integer.
	isfieldgroup	Represents the cache field is Field group
	IsFormulaField	Indicates the field is formula field
	IsString	Gets or sets a value indicating whether the cache field contains an string.
	ItemCount	Gets the count of items in the data collection.
	Name	Gets or sets the name of the field.

Methods

	Name	Description
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object .)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object .)
	GetHashCode	Serves as the default hash function. (Inherited from Object .)
	GetType	Gets the Type of the current instance. (Inherited from Object .)
	GetValue	Returns value at index.
	MemberwiseClone	Creates a shallow copy of the current Object . (Inherited from Object .)
	ToString	Returns a string that represents the current object. (Inherited from Object .)