XmlMap Object [Excel 2003 VBA Language Reference]

Multiple objects XmlMap Multiple objects

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

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

Using the XmlMap Object

Use the Add method of the XmlMaps collection to add an XML map to a workbook.

Importing and exporting XML data

Use the Import method to import XML data from an XML data file into cells mapped to the specified XmlMap. The ImportXml method imports XML data for a String variable.

Use the Export method to export data from cells mapped to the specified XmlMap. The ExportXml method exports XML data to a String variable.

Properties | AdjustColumnWidth Property | AppendOnImport Property | Application Property | Creator Property | DataBinding Property | IsExportable Property | Name Property | Parent Property | PreserveColumnFilter Property | PreserveNumberFormatting Property | RootElementName Property | RootElementNamespace Property | SaveDataSourceDefinition Property | Schemas Property | ShowImportExportValidationErrors Property

Methods | Delete Method | Export Method | ExportXml Method | Import Method | ImportXml Method

Parent Objects | ListObject Object | XmlMaps Collection | XPath Object

Child Objects | XmlDataBinding Object | XmlNamespace Object | XmlSchemas Object

See Also | XmlDataBinding Object | XmlMaps Collection | XmlNamespace Object | XmlNamespaces Collection | XmlSchema Object | XmlSchemas Collection | XPath Object