Excel Data Objects

CalculatedFields (1997) A collection of PivotField objects that represents all the calculated fields in the specified PivotTable report. For example, a report that contains Revenue and Expense fields could have a calculated field named Profit defined as the amount in the Revenue field minus the amount in the Expense field.

Add(Name, Formula, [UseStandardFormula])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

CalculatedItems (1997) A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report. For example, a PivotTable report that contains January, February, and March items could have a calculated item named FirstQuarter defined as the sum of the amounts in January, February, and March.

Add(Name, Formula, [UseStandardFormula])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

CalculatedMember (2002) Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.

Application
Creator
Delete()
Formula
IsValid
Name
Parent
SolveOrder
SourceName
Type

CalculatedMembers (2002) A collection of all the CalculatedMember objects on the specified PivotTable. Each CalculatedMember object represents a calculated field or calculated item.

Add(Name, Formula, [SolveOrder], [Type])
Application
Count
Creator
GetEnumerator()
Item
Parent

CubeField (2000) Represents a hierarchy or measure field from an CubeFields collection.

AddMemberPropertyField(Property, [PropertyOrder])
Application
Caption
Creator
CubeFieldType
Delete()
DragToColumn [= setting]
DragToData [= setting]
DragToHide [= setting]
DragToPage [= setting]
DragToRow [= setting]
EnableMultiplePageItems [= setting]
HasMemberProperties
HiddenLevels [= setting]
LayoutForm [= setting]
LayoutSubtotalLocation [= setting]
Name
Orientation [= setting]
Parent
PivotFields
Position [= setting]
ShowInFieldList [= setting]
TreeviewControl
Value

CubeFields (2000) A collection of all cube. Each CubeField object represents a hierarchy or measure field from the cube.

AddSet(Name, Caption)
Application
Count
Creator
GetEnumerator()
Item
Parent

DataTable (1997) Represents a chart data table.

Application
AutoScaleFont [= setting]
Border
Creator
Delete()
Font
HasBorderHorizontal [= setting]
HasBorderOutline [= setting]
HasBorderVertical [= setting]
Parent
Select()
ShowLegendKey [= setting]

IRtdServer (2002) Represents an interface for a real-time data server.

ConnectData(TopicID, Strings, GetNewValues)
DisconnectData(TopicID)
Heartbeat()
RefreshData(TopicCount)
ServerStart(CallbackObject)
ServerTerminate()

IRTDUpdateEvent (2002) Represents real-time data update events.

Disconnect()
HeartbeatInterval [= setting]
UpdateNotify()

ODBCError (1997) Represents an ODBC error generated by the most recent ODBC query. The ODBCError object is a member of the ODBCErrors collection. If the specified ODBC query runs without error, the ODBCErrors collection is empty. The errors in the collection are indexed in the order in which theyre generated by the ODBC data source.

Application
Creator
ErrorString
Parent
SqlState

ODBCErrors (1997) A collection of ODBCError objects. Each ODBCError object represents an error returned by the most recent ODBC query. If the specified ODBC query runs without error, the ODBCErrors collection is empty. The errors in the collection are indexed in the order in which theyre generated by the ODBC data source. You cannot add members to the collection.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

OLEDBError (2000) Represents an OLE DB error returned by the most recent OLE DB query. The OLEDBError object is a member of the OLEDBErrors collection. If the specified OLE DB query runs without error, the OLEDBErrors collection is empty. The errors in the collection are indexed in the order in which they are generated by the OLE DB provider.

Application
Creator
ErrorString
Native
Number
Parent
SqlState
Stage

OLEDBErrors (2000) A collection of OLEDBError objects. Each OLEDBError object represents an error returned by the most recent OLE DB query. If the specified OLE DB query runs without error, the OLEDBErrors collection is empty. The errors in the collection are indexed in the order in which they are generated by the OLE DB provider. You cannot add members to the collection.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

Parameter (1997) Represents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.

Application
Creator
DataType [= setting]
Name [= setting]
Parent
PromptString
RefreshOnChange [= setting]
SetParam(Type, Value)
SourceRange
Type
Value

Parameters (1997) A collection of Parameter objects for the specified query table. Each Parameter object represents a single query parameter. Every query table contains a Parameters collection, but the collection is empty unless the query table is using a parameter query.

Add(Name, [iDataType])
Application
Count
Creator
Delete()
GetEnumerator()
Item(Index)
Parent

PivotCache (1997) Represents the memory cache for a PivotTable report. The PivotCache object is a member of the PivotCaches collection.

ADOConnection
Application
BackgroundQuery [= setting]
CommandText [= setting]
CommandType [= setting]
Connection [= setting]
CreatePivotTable(TableDestination, [TableName], [ReadData], [DefaultVersion])
Creator
EnableRefresh [= setting]
Index
IsConnected
LocalConnection [= setting]
MaintainConnection [= setting]
MakeConnection()
MemoryUsed
MissingItemsLimit [= setting]
OLAP
OptimizeCache [= setting]
Parent
QueryType
RecordCount
Recordset [= setting]
Refresh()
RefreshDate
RefreshName
RefreshOnFileOpen [= setting]
RefreshPeriod [= setting]
ResetTimer()
RobustConnect [= setting]
SaveAsODC(ODCFileName, [Description], [Keywords])
SavePassword [= setting]
SourceConnectionFile [= setting]
SourceData [= setting]
SourceDataFile
SourceType
Sql [= setting]
UseLocalConnection [= setting]

PivotCaches (1997) Represents the collection of memory caches from the PivotTable reports in a workbook. Each memory cache is represented by a PivotCache object.

Add(SourceType, [SourceData])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotCell (2002) Represents a cell in a PivotTable report.

Application
ColumnItems
Creator
CustomSubtotalFunction
DataField
Dummy18
Parent
PivotCellType
PivotField
PivotItem
PivotTable
Range
RowItems

PivotField (1997) Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.

AddPageItem(Item, [ClearList])
Application
AutoShow(Type, Range, Count, Field)
AutoShowCount
AutoShowField
AutoShowRange
AutoShowType
AutoSort(Order, Field)
AutoSortField
AutoSortOrder
BaseField [= setting]
BaseItem [= setting]
CalculatedItems()
Calculation [= setting]
Caption [= setting]
ChildField
ChildItems
Creator
CubeField
CurrentPage [= setting]
CurrentPageList [= setting]
CurrentPageName [= setting]
DatabaseSort [= setting]
DataRange
DataType
Delete()
DragToColumn [= setting]
DragToData [= setting]
DragToHide [= setting]
DragToPage [= setting]
DragToRow [= setting]
DrilledDown [= setting]
EnableItemSelection [= setting]
Formula [= setting]
Function [= setting]
GroupLevel
HiddenItems
HiddenItemsList [= setting]
IsCalculated
IsMemberProperty
LabelRange
LayoutBlankLine [= setting]
LayoutForm [= setting]
LayoutPageBreak [= setting]
LayoutSubtotalLocation [= setting]
MemoryUsed
Name [= setting]
NumberFormat [= setting]
Orientation [= setting]
Parent
ParentField
ParentItems
PivotItems([Index])
Position [= setting]
PropertyOrder [= setting]
PropertyParentField
ServerBased [= setting]
ShowAllItems [= setting]
SourceName
StandardFormula [= setting]
SubtotalName [= setting]
Subtotals [= setting]
TotalLevels
Value [= setting]
VisibleItems

PivotFields (1997) A collection of all the PivotField objects in a PivotTable report.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotFormula (1997) Represents a formula used to calculate results in a PivotTable report.

Application
Creator
Delete()
Formula [= setting]
Index [= setting]
Parent
StandardFormula [= setting]
Value [= setting]

PivotFormulas (1997) Represents the collection of formulas for a PivotTable report. Each formula is represented by a PivotFormula object.

Add(Formula, [UseStandardFormula])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotItem (1995) Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.

Application
Caption [= setting]
ChildItems
Creator
DataRange
Delete()
DrilledDown [= setting]
Formula [= setting]
IsCalculated
LabelRange
Name [= setting]
Parent
ParentItem
ParentShowDetail
Position [= setting]
RecordCount
ShowDetail [= setting]
SourceName
SourceNameStandard
StandardFormula [= setting]
Value [= setting]
Visible [= setting]

PivotItemList (2002) A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotItems (1995) A collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.

Add(Name)
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotLayout (2000) Represents the placement of fields in a PivotChart report.

AddFields([RowFields], [ColumnFields], [PageFields], [AppendField])
Application
ColumnFields
Creator
CubeFields
DataFields
HiddenFields
InnerDetail [= setting]
PageFields
Parent
PivotCache
PivotFields
PivotTable
RowFields
VisibleFields

PivotTable (1995) Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.

AddDataField(Field, [Caption], [Function])
AddFields([RowFields], [ColumnFields], [PageFields], [AddToTable])
Application
CacheIndex [= setting]
CalculatedFields()
CalculatedMembers
ColumnFields
ColumnGrand [= setting]
ColumnRange
CreateCubeFile(File, [Measures], [Levels], [Members], [Properties])
Creator
CubeFields
DataBodyRange
DataFields
DataLabelRange
DataPivotField
DisplayEmptyColumn [= setting]
DisplayEmptyRow [= setting]
DisplayErrorString [= setting]
DisplayImmediateItems [= setting]
DisplayNullString [= setting]
Dummy15(Arg1, [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
EnableDataValueEditing [= setting]
EnableDrilldown [= setting]
EnableFieldDialog [= setting]
EnableFieldList [= setting]
EnableWizard [= setting]
ErrorString [= setting]
Format(Format)
GetData(Name)
GetPivotData([DataField], [Field1], [Item1], [Field2], [Item2], [Field3], [Item3], [Field4], [Item4], [Field5], [Item5], [Field6], [Item6], [Field7], [Item7], [Field8], [Item8], [Field9], [Item9], [Field10], [Item10], [Field11], [Item11], [Field12], [Item12], [Field13], [Item13], [Field14], [Item14])
GrandTotalName [= setting]
HasAutoFormat [= setting]
HiddenFields
InnerDetail [= setting]
ListFormulas()
ManualUpdate [= setting]
MDX
MergeLabels [= setting]
Name [= setting]
NullString [= setting]
PageFieldOrder [= setting]
PageFields
PageFieldStyle [= setting]
PageFieldWrapCount [= setting]
PageRange
PageRangeCells
Parent
PivotCache()
PivotFields([Index])
PivotFormulas
PivotSelect(Name, [Mode], [UseStandardName])
PivotSelection [= setting]
PivotSelectionStandard [= setting]
PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection])
PreserveFormatting [= setting]
PrintTitles [= setting]
RefreshDate
RefreshName
RefreshTable()
RepeatItemsOnEachPrintedPage [= setting]
RowFields
RowGrand [= setting]
RowRange
SaveData [= setting]
SelectionMode [= setting]
ShowCellBackgroundFromOLAP [= setting]
ShowPageMultipleItemLabel [= setting]
ShowPages([PageField])
SmallGrid [= setting]
SourceData [= setting]
SubtotalHiddenPageItems [= setting]
TableRange1
TableRange2
TableStyle [= setting]
Tag [= setting]
TotalsAnnotation [= setting]
Update()
VacatedStyle [= setting]
Value [= setting]
Version
ViewCalculatedMembers [= setting]
VisibleFields
VisualTotals [= setting]

PivotTables (1995) A collection of all the PivotTable objects on the specified worksheet.

Add(PivotCache, TableDestination, [TableName], [ReadData], [DefaultVersion])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

QueryTable (1997) Represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.

AdjustColumnWidth [= setting]
AfterRefresh
Application
BackgroundQuery [= setting]
BeforeRefresh
CancelRefresh()
CommandText [= setting]
CommandType [= setting]
Connection [= setting]
CreateObjRef(requestedType)
Creator
Delete()
Destination
EditWebPage [= setting]
EnableEditing [= setting]
EnableRefresh [= setting]
Equals(obj)
FetchedRowOverflow
FieldNames [= setting]
FillAdjacentFormulas [= setting]
GetHashCode()
GetLifetimeService()
GetType()
HasAutoFormat [= setting]
InitializeLifetimeService()
ListObject
MaintainConnection [= setting]
Name [= setting]
Parameters
Parent
PostText [= setting]
PreserveColumnInfo [= setting]
PreserveFormatting [= setting]
QueryType
Recordset [= setting]
Refresh([BackgroundQuery])
Refreshing
RefreshOnFileOpen [= setting]
RefreshPeriod [= setting]
RefreshStyle [= setting]
ResetTimer()
ResultRange
RobustConnect [= setting]
RowNumbers [= setting]
SaveAsODC(ODCFileName, [Description], [Keywords])
SaveData [= setting]
SavePassword [= setting]
SourceConnectionFile [= setting]
SourceDataFile [= setting]
Sql [= setting]
TablesOnlyFromHTML [= setting]
TextFileColumnDataTypes [= setting]
TextFileCommaDelimiter [= setting]
TextFileConsecutiveDelimiter [= setting]
TextFileDecimalSeparator [= setting]
TextFileFixedColumnWidths [= setting]
TextFileOtherDelimiter [= setting]
TextFileParseType [= setting]
TextFilePlatform [= setting]
TextFilePromptOnRefresh [= setting]
TextFileSemicolonDelimiter [= setting]
TextFileSpaceDelimiter [= setting]
TextFileStartRow [= setting]
TextFileTabDelimiter [= setting]
TextFileTextQualifier [= setting]
TextFileThousandsSeparator [= setting]
TextFileTrailingMinusNumbers [= setting]
TextFileVisualLayout [= setting]
ToString()
WebConsecutiveDelimitersAsOne [= setting]
WebDisableDateRecognition [= setting]
WebDisableRedirections [= setting]
WebFormatting [= setting]
WebPreFormattedTextToColumns [= setting]
WebSelectionType [= setting]
WebSingleBlockTextImport [= setting]
WebTables [= setting]

QueryTables (1997) A collection of QueryTable objects. Each QueryTable object represents a worksheet table built from data returned from an external data source.

Add(Connection, Destination, [Sql])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

RefreshEvents (1997) Hidden or unsupported element.

AfterRefresh(Success)
BeforeRefresh(Cancel)

RTD (2002) Represents a real-time data object.

RefreshData()
RestartServers()
ThrottleInterval [= setting]