Read text file XML and pass it to excel

Help
, ,
1

20100346631-01-F003-00004336.xml (9.5 KB) IterateXml.xaml (14.0 KB) project.json (955 Bytes)

a method to pass this data from the xml file to excel
is there any way? And if you can only pass specific data?

thank you very much in advance

2

Your file is not opening, can you zip the project.json file and share @borismh?

And I hope you are using deserialize XML to get the required values and then writing them to excel. If you are doing that, then it will be ok

3

@HareeshMR
IterateXMLZIP.zip (3.6 KB)

if I used to deserialize but I don’t know how to pass it to excel, or have a command just to select certain values
Thanks in advance

4

If you are getting a set of data which is relatively same, you can add them to the array or to the collections or simply the write cell activities with dynamic range @borismh . Or if you get the data in the form of rows (I mean, the data to be added in a single row of excel) go for build data table. :slight_smile:

5

@HareeshMR

And how do I do that, excuse me?

6

Can you explain what is the data you want to get from the XML clearly @borismh? So that I can build you the workflow for your reference

7

@HareeshMR

ds:Signature = “”
cbc:UBLVersionID = “”
cbc:CustomizationID = “”
cbc:ProfileID = “”
cbc:ID = “”
cbc:IssueDate = “”
cbc:IssueTime = “”
cbc:DueDate = “”
cbc:InvoiceTypeCode = “”

those are some, but there is no term to extract the data, and only change the name to obtain information
Thanks in advance

8

Lot of work to do @borismh :smiley:

Can you just try deserialize activity and pass it to for each activity so that you can get the parts of XML?

From those, you will get the required easily, and you will easily understand

1 Like
9

@HareeshMR
that is deserialized and has the “for each”
, but after doing that, what do I put to pass it to excel

10

You can use write cell activity within excel application scope to write the data, or else you can add that to a data table and then you can write to excel @borismh

Please let me know if it is confusing :slight_smile:

11

Hi @borismh - If you have .xml file then you can directly import the data in excel using Excel only.
It can directly convert the xml data in Table and it is very helpful feature.
Here is the option available to do that.
image
You can also check this link as well.

Hope it helps.

Best!!
Anmol