I have a huge XML which I want to import in excel. Here is a piece of the XML which I want to import.\[code\]<ROOT> <ELEMENTS> <ELEMENT1> <A>1</A> <B>2</B> <C>3</C> </ELEMENT1> <ELEMENT2> <A>3</A> <B>2</B> <C>1S</C> </ELEMENT2> </ELEMENTS></ROOT>\[/code\]When I import this XML to Excel I see headers as \[code\]A\[/code\], \[code\]B\[/code\] and \[code\]C\[/code\], but I don't get \[code\]ELEMENT1\[/code\] and \[code\]ELEMENT2\[/code\] as headers.
What am I doing wrong here? My XML structure is nice and I am getting a well parsed XML.
What am I doing wrong here? My XML structure is nice and I am getting a well parsed XML.