Extracting excel row values one by one

Help
1

Hai all
I am having only one column in excel and number of rows will vary. I need the values of the row. In my case, 1st we have to take the first row value and paste it in the browser and download the file. Once the download is completed 2nd value in the excel should be pasted. It should be repeated until all values from the rows are taken from excel. Please provide a sample xaml file for this scenario.
Thanks in advance

1 Like
2

To do that you have to extract the value of the cells until an empty cell is encountered.

2 Likes
3

i had recently written a flow for something similar … here is the relevant part for you Main.xaml (10.5 KB)

1 Like
4

HI @Newton_Rich_SV

You can try the below steps.

  1. Use a Read Range activity to read the excel into a datatable
  2. Drag and drop a For Each Row activity to loop through the data table
  3. within the loop, include all your download related activities

This way, you can easily access all the rows in the excel and download the file for each of those from the website…

Hope it helps!! Let know how it goes for you…

1 Like
5

Thank you guys.
It was helpful

2 Likes
6

@Newton_Rich_SV if anyone of us was able to solve your issue please mark the appropriate answer as the solution. :slight_smile:

1 Like
7

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