Read the subject from XML file and store them into excel file

Hi there,

I’m facing some problem when pasting out the stored data into the column of excel file. What I need to do is that I wish to paste the stored data one by one/column by column into my excel file.
Example:
I got 5 results (food name) stored in my clipboard.
I want to paste 5 of my results one by one as per column in the excel file. That is, A1 B1 C1 D1 E1.

I can iterate through the program but my result always come out with stored data only appears on the first column. What can I do to resolve the problem? I had attached my project file here.

I appreciate any reply. Thanks in advance.

Copy Text.xaml (9.0 KB) project.json (744 Bytes) SampleXML.xml (1.0 KB) test.xlsx (8.5 KB)

Hi @yushinchan,
since you are extracting values from xml , why not we create a DT and insert values in it instead of clipboard?Copy Text.xaml (15.4 KB) test.xlsx (10.0 KB)

This is also such a good way to execute this project. I’ll refer to your suggestion as well.
Thanks for your sharing :’)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.