XlXmlLoadOption Enumeration
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. |