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)