Apr 01 2021 12:08 AM
Hi
I'm trying to manage a database more efficiently but when i tried to follow the tutorials, i dont have the import xml option in both data ribbon and developer ribbon
and when i say import i meant organized table of data entries and not just the copy pasted code from xml
(learning to export xml is also appreciated) thanks ahead
Apr 01 2021 12:18 AM
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.
If you have an XML Map, do this to import XML data into mapped cells:
In the XML Map, select one of the mapped cells.
Click Developer > Import.
If you don't see the Developer tab, see Show the Developer tab.
In the Import XML dialog box, locate and select the XML data file (.xml) you want to import, and click Import.
more info on...Import XML data
Hope I was able to help you with this info.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Apr 01 2021 03:06 AM
Apr 01 2021 07:50 AM
Apr 01 2021 09:40 AM
If the Developer tab is not available, do the following to display it:
Select Excel > Preferences > Ribbon & Toolbar.
Under Customize the Ribbon, select Main Tabs and then check Developer.
Click Save and then close Excel Preferences.
Apr 09 2021 11:28 AM
Apr 09 2021 12:11 PM
@Iris_Huang0129 That's because the XML options are NOT available on Excel for Mac!
Apr 09 2021 12:39 PM
I actually went through Microsoft's documents step by step to help you.
But as far as I can read, Mr. Riny_van_Eekelen has informs that this option is not available in Mac.
It is strange that Microsoft gives this possibility, but I trust Mr. Riny_van_Eekelen expertise and knowledge.
Sorry if I have not given you correct information.
Thank you for your understanding and your time.
Nikolino
I know I don't know anything (Socrates)
Apr 21 2021 03:59 PM
@Riny_van_Eekelen, @Riny_van_Eekelen i see thanks
Jun 02 2021 03:49 PM