Excel XML Objects

CustomProperties (2002) A collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.

Add(Name, Value)
Application
Count
Creator
GetEnumerator()
Item
Parent

CustomProperty (2002) Represents identifier information. Identifier information can be used as metadata for XML.

Application
Creator
Delete()
Name [= setting]
Parent
Value [= setting]

ListColumn (2003) Represents a column in a ListObject object).

Application
Creator
Delete()
Index
ListDataFormat
Name [= setting]
Parent
Range
SharePointFormula
TotalsCalculation [= setting]
XPath

ListColumns (2003) A collection of all the ListColumn objects in the specified ListColumn object represents a column in the list.

Add([Position])
Application
Count
Creator
GetEnumerator()
Item
Parent

ListDataFormat (2003) The ListColumn object. These properties are read-only.

AllowFillIn
Application
Choices
Creator
DecimalPlaces
DefaultValue
IsPercent
lcid
MaxCharacters
MaxNumber
MinNumber
Parent
ReadOnly
Required
Type

ListObject (2003) Represents a list object on a worksheet. The ListObjects collection contains all the list objects on a worksheet.

Active
Application
Creator
DataBodyRange
Delete()
DisplayRightToLeft
HeaderRowRange
InsertRowRange
ListColumns
ListRows
Name [= setting]
Parent
Publish(Target, LinkSource)
QueryTable
Range
Refresh()
Resize(Range)
SharePointURL
ShowAutoFilter [= setting]
ShowTotals [= setting]
SourceType
TotalsRowRange
Unlink()
Unlist()
UpdateChanges([iConflictType])
XmlMap

ListObjects (2003) A collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.

Add([SourceType], [Source], [LinkSource], [XlListObjectHasHeaders], [Destination])
Application
Count
Creator
GetEnumerator()
Item
Parent

ListRow (2003) Represents a row in a List object. The ListRow object is a member of the ListRows collection contains all the rows in a list object.

Application
Creator
Delete()
Index
InvalidData
Parent
Range

ListRows (2003) A collection of all the ListRow objects in the specified ListRow object represents a row in the list.

Add([Position])
Application
Count
Creator
GetEnumerator()
Item
Parent

XmlDataBinding (2003) Represents the connection to the source data for an XmlMap object.

Application
ClearSettings()
Creator
LoadSettings(Url)
Parent
Refresh()
SourceUrl

XmlMap (2003) Represents an XML map that has been added to a workbook.

AdjustColumnWidth [= setting]
AppendOnImport [= setting]
Application
Creator
DataBinding
Delete()
Export(Url, [Overwrite])
ExportXml(Data)
Import(Url, [Overwrite])
ImportXml(XmlData, [Overwrite])
IsExportable
Name [= setting]
Parent
PreserveColumnFilter [= setting]
PreserveNumberFormatting [= setting]
RootElementName
RootElementNamespace
SaveDataSourceDefinition [= setting]
Schemas
ShowImportExportValidationErrors [= setting]

XmlMaps (2003) Represents the collection of XmlMap objects that have been added to a workbook.

Add(Schema, [RootElementName])
Application
Count
Creator
GetEnumerator()
Item
Parent

XmlNamespace (2003) Represents a namespace that has been added to a workbook.

Application
Creator
Parent
Prefix
Uri

XmlNamespaces (2003) Represents the collection of XmlNamespace objects in a workbook.

Application
Count
Creator
GetEnumerator()
InstallManifest(Path, [InstallForAllUsers])
Item
Parent
Value

XmlSchema (2003) Represents an XML schema contained by an XmlMap object.

Application
Creator
Name
Namespace
Parent
XML

XmlSchemas (2003) Represents the collection of XmlMap object.

Application
Count
Creator
GetEnumerator()
Item
Parent

XPath (2003) Represents an XPath that has been mapped to a ListColumn object.

Application
Clear()
Creator
Map
Parent
Repeating
SetValue(Map, XPath, [SelectionNamespace], [Repeating])
Value