How to read excel file with dynamic rows?

Hello,

I built a robot to save an attachment (excel file) from an outlook email, which i will receive it daily. My question is how can i use the read cell activity even if the row placement will differ from day to day.

Appreciate your suuport.

Thanks.

@alqahtanimfar.c Welcome To Community

Why don’t you try to read range and then loop through each row…

It will work dynamically

Hello, @alqahtanimfar.c is there any kind of rule to this row placement?
You can try, as @Pravin_Patil1 said, use read Range Activity and threat your data as
Data Table. It will be much more simple.

Hi @alqahtanimfar.c ,

Welcome to UiPath Community!
Can you please elaborate the excel purpose?

Regards
Balamurugan.S

how this would help?
if i want to read cell 100 for todays excel & tomorrows excel the same cell will be in a different cell number for example 103?

if i want to read cell 100 for todays excel & tomorrows excel the same cell will be in a different cell number for example 103?
can you elaborate more how to threat the data? i’m new in RPA

  1. Read range will help you to read all the cells from sheet. Without any fixed number. Just provide from where you want to start reading.
    Example : “A1” in range section of read range activity

  2. For each will help you to iterate through all the values in data table one by one