This documentation is archived and is not being maintained.

XlXmlLoadOption Enumeration 

Specifies how Excel opens the XML data file.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlXmlLoadOption1 As XlXmlLoadOption = XlXmlLoadOption.xlXmlLoadImportToList

Public Enum XlXmlLoadOption
public enum XlXmlLoadOption
public enum XlXmlLoadOption

Member nameDescription
xlXmlLoadImportToListPlaces the contents of the XML data file in an XML list.
xlXmlLoadMapXmlDisplays the schema of the XML data file in the XML Structure task pane.
xlXmlLoadOpenXmlOpens the XML data file. The contents of the file will be flattened.
xlXmlLoadPromptUserPrompts the user to choose how to open the file.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms