XlXmlLoadOption Enumeration (Excel)

Specifies how Excel opens the XML data file.

Name Value Description
xlXmlLoadImportToList 2 Places the contents of the XML data file in an XML table.
xlXmlLoadMapXml 3 Displays the schema of the XML data file in the XML Structure task pane.
xlXmlLoadOpenXml 1 Opens the XML data file. The contents of the file will be flattened.
xlXmlLoadPromptUser 0 Prompts the user to choose how to open the file.