Code to convert xml into a table

Help Something Else
,
1

Hello just opened this xml as a text file and here is what i see. Please I would love to change it to a table in the most effective way
image

image
sample.xml (148 Bytes)

2

@MasterOfLogic,

Check this xaml, I am reading the XML from my desktop.
XMLToDataTable.xaml (7.3 KB)

3

The readXML Method requires some structures, but the provided XML is not matching this.

We can do as an alternate like this:

grafik
grafik1139×895 98.1 KB

dtData =

(From row In xDoc.Descendants("row")
Let ra = row.Descendants("column").Select(Function (x) x.Value).toArray
Select r = dtData.Rows.Add(ra)).CopyToDataTable

grafik

find starter help here:
ppr_XMLBox_MasterOfLogic.xaml (8.6 KB)

4

hello thank you , please help again its still half way to go
image

5

hello thank you , please can I still achieve this without deserialize activity. i might be moving it out of uipath

6

may we ask you to elaborate more on this? Thanks

7

I am converting the code to a pure c# code and i wanna be able to call my code in several rpa solutions…i.e blue prism & uipath. i will need this deserialze xaml actvity in .net code too

8

As an alternate you can do:
grafik
xDoc = XDocument.Parse(strXML)