Excel filter->move to other sheet

Help
1

i am extracting client data from web.
I extract one client at a time, so data goes to excel.

I loop the sequence, but my issue is:
The extracted data, that I sort and manipulate - how do i paste in new sheet next to, or rather below, the last pasted info?
I have more than one line for each client, and might not be similar lines for each client.

So for example i have three clients A,B,C
I need data like this
A, Car no1, salary
B, Car no1, salary
B, Car no2, salary
C, Car no1, salary

When I extract I get to the point where i have this:
B, Car no1, salary
B, Car no2, salary

And now need to paste below
A, Car no1, salary

2

Hi @MartinSeren,
Welcome to the community!
Have you tried using Append Range activity?
Thanks and regards

2 Likes
3

I copied data using:

image

and as i can tell Append needs a data table?

4

Just tried this - not working

image
image442×638 17.4 KB

5

Please use excel activities than using keyboard activities :slight_smile:

2 Likes
6

Please refer to this link: https://activities.uipath.com/docs/about-the-excel-activities-pack
Thanks and regards

1 Like
7

Closer now.

If I have a data table, that I have filtered.
How do I unfilter?
image

8

If you want each customer data in each sheet you can use Shift+F11 to insert new sheet in a excel after every Customers data or you can use the send hot key’s CTRL+SHIFT+Down and Down For pasting each customer data without blank line. if you wank one blank line in between you can add another Down.

@Jan_Brian_Despi, As I am new to UIPath, I will check with excel scope and will replay soon.

@MartinSeren Try this…

1 Like
9

The issue was actually not in excel - as I thought.
The issue was, that Uipath kept adding data to the Datatable - so when excel pasted it kept pasting more and more info, and the same info every time (including the new info).
Solution was to empty datatable before adding new info.

Thanx for your info!

1 Like