Copy Paste specific excel row to another excel

Help Studio
1

Hi guys, I’m very much new to this UIPath as this is my new working assignment. (Sorry I can’t upload more pictures due to new member rule)

The title said it all, I want to copy rows contain “Approval” only and paste those content into new excel.

This is my condition code but the output end up copy everything and paste it on new excel including non-“Approval” content.

problem3
problem3720×608 15.2 KB

Really appreciate for help :smiley:

2

Hello @Aldrin_Pro,
Welcome to Uipath Forum!!!

Can you share excel or its Screenshot

2 Likes
3

Hi.
How about building data table first? not ‘write range’ directly?

4

I want to copy specific approval content just like below attachment into new excel
problem 1

5

New excel will be pasted like this :
problem2

6

I have the data table for bot to copy, but upon pasted into new excel must be generate a new one.

7

Check this,
Test.xlsx (8.9 KB) Main.xaml (8.0 KB)

4 Likes
8

I mean you can build new data table first and then write the data table on excel.
Because according your code, you may overwrite the value on Sheet1-A1.

1 Like
9

Thanks man, it works ! Still need to learn how to use this data table thing.

10

Yeah, I missing the data table, still need to learn how to use it, anyway thanks :smiley:

11

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