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