Get Text to new Excel Row after every Repeat

Help StudioX
1

Hi guys,

A very simple one which I can’t get working.

I have got a workflow setup which Get Text and Paste into an Excel. This then repeats.

The issue I am having is how do I put the data into a new row (but same column) every time it.

Main
Main1111×1711 113 KB

Any help? Only new to UI Path and couldn’t find a solution at all.

Thanks

2

Hi @hydie (how do I put the data into a new row (but same column) every time it.)
You can use Data table activities that you can add a data row, and create a Data table and you can write into excel

(or)
Take a counter Variable Counter=1
Take while loop and Take Write cell activity and pass Range value as ColumnName+Counter

can you please attach workflow you have created. Then it is easier to gave you solution.

Thanks
Latika

3

After playing around I ended up putting in an Append Range, however not everything lines up correctly (A SKU is on the line below where it should be). This needs to be fixed.

Here is a screenshot of the workflow and also the file. It is getting data from an Application.

Main1
Main11043×2164 138 KB

Xentry.zip (84.1 KB)