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, 2020 in RPA by anonymous
• 130 points
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 28, 2020 by vikky
• 520 points

Related Questions In RPA

0 votes
1 answer
0 votes
0 answers

How can I extract data from multiple different PDFs from same folder using config file in uipath ??

How can I extract data from multiple ...READ MORE

Nov 5, 2020 in RPA by anonymous
• 19,620 points
0 votes
2 answers

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

Use the utility something which contains Get ...READ MORE

answered Jul 10, 2020 in RPA by jananidhamu98@
• 550 points
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
+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
+15 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 27, 2018 in DevOps & Agile by DragonLord999
• 8,450 points