How can I extract data dynamically

0 votes
How can I extract data from application and save it on excel one by one, means get data from excell column 1 and then fetch data and save it on column 2 then again get data from column 1 and save it just below where  first fetch data was save.
Apr 25 in RPA by anonymous
• 130 points
130 views
You want to know how to extract data from an excel sheet that changes dynamically? Is that your query?
Yes, but write data in column 2 just before the data in column 1
Have you tried vikky's solution?

1 answer to this question.

+1 vote
you need to use for loop

in that for each row in you column1 you need to search that in application and output of that you can write it into another csv file (use append csv) so for next row of column1 your result will be stored in the other CSV's row2.

when that for loop is completed then in the end you can use a excel application scope

in which you can run a macro to merge both input and output sheet.
answered Apr 27 by vikky
• 520 points

Related Questions In RPA

0 votes
1 answer
0 votes
1 answer

how can i add collection data to csv in blue prism?

I've done this, but I dont have ...READ MORE

answered Oct 5, 2018 in RPA by Priyaj
• 57,530 points
2,369 views
0 votes
1 answer

How can I extract numbers between $ symbol using UiPath?

Hi Avani, you can extract the numbers ...READ MORE

answered Mar 18, 2019 in RPA by Pratibha
• 3,690 points
2,192 views
0 votes
1 answer

How can I handle and follow Links Using Web Element in RPA Express?

Workfusion RPA Express version 1.2.0, Web elements ...READ MORE

answered Oct 22, 2018 in RPA by Priyaj
• 57,530 points
519 views
+5 votes
7 answers

Docker swarm vs kubernetes

Swarm is easy handling while kn8 is ...READ MORE

answered Aug 27, 2018 in Docker by Mahesh Ajmeria
1,232 views
+13 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 26, 2018 in DevOps & Agile by DragonLord999
• 8,420 points
498 views