XmlMap Object [Excel 2003 VBA Language Reference]
Multiple objects.gif) XmlMap.gif) 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