XmlMap object (Excel)

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

Remarks

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

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.

Methods

• Delete
• Export
• ExportXml
• Import
• ImportXml

Properties

• AdjustColumnWidth
• AppendOnImport
• Application
• Creator
• DataBinding
• IsExportable
• Name
• Parent
• PreserveColumnFilter
• PreserveNumberFormatting
• RootElementName
• RootElementNamespace
• SaveDataSourceDefinition
• Schemas
• ShowImportExportValidationErrors
• WorkbookConnection

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.