Reading all the tags of an XML and take them to excel

Help Studio
, , ,
4

@Fabian_DDD

I do feel that a XPath Approach is better for the retrieval

Setting up a NamespaceManager with a Config Datatable:
grafik

for the default namespace with empty prefix “def” is assigne as prefix

the retrieval is configured as another datatable (could also be externalize into an excel)

grafik
grafik1030×188 6.29 KB

I did also for a deeper nested element for demo purpose

After all preperation it is iterating over the retrieval config and retrieves the specfied values. et voila:
grafik

So this result can be used and preprocess (e.g. removing path column, dynamic reating another structure…)

I did it as a quick prototype for you and you can finalize.

Open the XML in Chrome or Firefox and activate the Webtools (F12)
with following you can easy get the Xpath: Kopieren means Copy:
grafik

Demo XAML here:
Lector_V2.xaml (16.7 KB)

1 Like