How to read one by one row of excel?

Help Studio
, ,
1

Hi Team,

How to read excel data one by one row?
Right now i am using “Read range workbook” activity but i am getting output of 1st row. Please help me how to read below table value of every row.

Start date End date
2/11/2022 5/22/2023
6/5/2022 8/5/2023
5/5/2021 8/5/2023
4/5/2019 8/5/2023

@mkankatala any solution?

2

Hi @Smitesh_Aher2

You can use for each row in datatable activity to iterate through each row in a datatable. For every iteration you will get each row.

Hope it helps!!

3

hello @Smitesh_Aher2
first use range workbook activity and then for each row in datatable as shown below

forum
forum978×422 23.5 KB

regards,
Dheerandra Vishwakarma

4

Use
1.Readrange workbook activity the output is datatable
2.use For each row in data table to loop through the datatable

5

@dheerandra.vishwakarma , @mkankatala & @Gayathri_Mk Thanks for your response…

I am getting output value of only first row by using below expression in message box
currentrow(Start date).tosting

6

@Smitesh_Aher2
just only put currentrow in message box click on ok it will go to next row and so on…

7

Yes @Smitesh_Aher2

You will get the first value, If you click on ok button message box in next iteration the next row value will come. You are using for each row in datatable activity it will iterate through each row in datatable, in first iteration first row values will come in second iteration second row values will come and so on.

Hope you understand!!

8

After clicking on message box the process is going outside of the for loop. Only 1st value is showing me on message box.

9

Hi,

Bot is printing all the values,

image
image851×500 29 KB

Please find the attached xaml file.
Main.xaml (10.5 KB)

10

If it works for you, Please mark this as a solution… :slight_smile:

11

Could you share me the screenshot, what you are getting in the message box… @Smitesh_Aher2

12

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