XmlMap Members (Excel)

Represents an XML map that has been added to a workbook.

Methods

Name	Description
Delete	Removes the specified XML map from the workbook.
Export	Exports the contents of cells mapped to the specified XmlMap object to an XML data file.
ExportXml	Exports the contents of cells mapped to the specified XmlMap object to a String variable.
Import	Imports data from the specified XML data file into cells that have been mapped to the specified XmlMap object.
ImportXml	Imports XML data from a String variable into cells that have been mapped to the specified XmlMap object.

Properties

Name	Description
AdjustColumnWidth	True if the column widths are automatically adjusted for the best fit each time you refresh the specified XML map. False if the column widths aren’t automatically adjusted with each refresh. The default value is True. Read/write Boolean.
AppendOnImport	True if you want to append new rows to XML lists that are bound to the specified schema map when you are importing new data or refreshing an existing connection. False if you want to overwrite the contents of cells that are bound to the specified schema map when you are importing new data or refreshing an existing connection. The default value is False. Read/write Boolean.
Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
DataBinding	Returns an XmlDataBinding object that represents the binding associated with the specified schema map. Read-only.
IsExportable	Returns True if Microsoft Excel can use the XPath objects in the specified schema map to export XML data and all XML lists mapped to the specified schema map can be exported.
Name	Returns or sets a String value that represents the friendly name used to uniquely identify a mapping in the workbook.
Parent	Returns the parent object for the specified object. Read-only.
PreserveColumnFilter	Returns or sets whether filtering is preserved when the specified XML map is refreshed. Read/write Boolean.
PreserveNumberFormatting	True if number formatting on cells mapped to the specified XML schema map will be preserved when the schema map is refreshed. The default value is False. Read/write Boolean.
RootElementName	Returns a String that represents the name of the root element for the specified XML schema map. Read-only.
RootElementNamespace	Returns an XmlNamespace object that represents the root element for the specified XML schema map. Read-only.
SaveDataSourceDefinition	True if the data source definition of the specified XML schema map is saved with the workbook. The default value is True. Read/write Boolean.
Schemas	Returns an XmlSchemas collection that represents the schemas that the specified XmlMap object contains. Read-only.
ShowImportExportValidationErrors	Returns or sets whether to display a dialog box that details schema-validation errors when data is imported or exported through the specified XML schema map. The default value is False. Read/write Boolean.
WorkbookConnection	Retuns a new connection for the specified XMLMap object. Read-only.