PDA

View Full Version : XML Import Confussion



DanHowles
2019-09-30, 09:08 AM
Hey all,
First time poster here, so I hope this is the correct place to post this.
I'm looking to import an XML in to Excel but i'm having issues with it.

I've used the Import wizard and feel like I'm most of the way, but I'm missing something probably simple.
The XML I am trying to import is the XML for a game that I need statistics from and because I believe it is full of tables I'm struggling to access any information.

The XML is a few hundred records and has several columns, so a manual copy and paste job isn't really viable for me.

Opening the XML in the Importer seems good promising to being with, but investigating more just shows me the value of "table"
I was wondering if there is a way to get Excel to automatically pull each record's value inside these tables.
Screen shots to follow.

So opening the XML, gets me here
https://imgur.com/a/oYGt11w (https://www.mrexcel.com/forum/redirect-to/?redirect=https%3A%2F%2Fimgur.com%2Fa%2FoYGt11w)

And I can see most of the information, until I go further across and start to see the value "table" is shown for most of the cells.
https://imgur.com/a/3wV9Kgc (https://www.mrexcel.com/forum/redirect-to/?redirect=https%3A%2F%2Fimgur.com%2Fa%2F3wV9Kgc)

At the bottom the query is pulled from the correct table and if I double click I see the individual value.
However I would like to it too pull every and every value that says table in one clear spreadsheet.

I'm sure it's very simple, but after googling I can't seem to get a simple answer.
Thanks in advance,

-Dan

Bob Phillips
2019-09-30, 04:57 PM
Can you post the XML?

DanHowles
2019-09-30, 05:29 PM
Hey Bob,
Attached is the XML.
In there are several tables, I am looking at the "monsters" table, but i would like to eventually apply the same logic to everything here.

https://1drv.ms/u/s!AigUhyDVsz8Yg_cYUn9A_g7Ru6Up1A?e=EJone2 (https://1drv.ms/u/s!AigUhyDVsz8Yg-oXFkML5T0UpKqVUg?e=9QOYji)

p45cal
2019-12-13, 05:30 PM
cross posted here:
https://www.mrexcel.com/board/threads/xml-import-confussion.1111044/
and:
https://stackoverflow.com/questions/58172296/excel-xml-import-confusion-value-holding-as-table
I realise the imgur linksyou posted no longer work.