Hey, i want to collect data from excel file and write data but not using Excel Application Scope. i need to do this just like human being do

Help Studio
, ,
1

hey, i want to collect data from excel file and write data but not using Excel Application Scope. i need to do this just like human being do

2

@barm471
Hello
Be more specific please, but without Excel Scope, use Read Range activity, then loop through Data Table.

regards

3

I mean i need to “act” like human copy data from cell in excel and then paste it somewhere.

4

Why? That’s not the best way to do it. What reason do you have for trying to do it that way?

5

I know.
A company I want to accept requires this in a homework given to me…
I success doing this mission with Excel Application Scope…that was easy.
but what they ask now its doing this like human with copy data and paste it

6

I would explain to them why it’s not the correct way to do it. If they insist on having it done that way, I wouldn’t want to work for them.

1 Like
7

For traine, knowledge, test purpose it makes sense. They may want to know how you would do. Discove the way you think, your logic think etc

Look, to acchieve this you may need user some activities like Use Application, Get Text, Set to Clipboard, Copy Selected Value, Click Activity

This way, if user click in somewhere, you use Click Activity. If user copy text from somewhere, you can use Get Text, Copy Selected Text etc then if user paste text, you can you Type Into Activity and pass ctrl + v hotkey combination and so on

Try to think on this like little peaces of user interactions and compare these with UiPath user interaction activities, no matter which software user is using (Retire Excel from equation)

8

Ya you probably right…shame

9

Hey, so i try to do so…its not working so good but thank!
i cant find a way to iterate all the rows and collect the data from each cell and copy it in Generic way.