In the Import Data dialog box, do one of the following: If the XML data file doesn't refer to a schema, Excel infers the schema from the XML data file. Import multiple XML data files as external dataįor more information about issues, see Common issues with importing XML data at the end of this article. In the Import XML dialog box, locate and select the XML data file (.xml) you want to import, and click Import.
If you don't see the Developer tab, see Show the Developer tab. In the XML Map, select one of the mapped cells. If you have an XML Map, do this to import XML data into mapped cells: If you previously created an XML Map, you can use it to import XML data into cells that are mapped, but there also are several methods and commands for importing XML data without an XML Map.
0 kommentar(er)
