How to read excel file with dynamic rows?

Help Studio
, , , ,
1

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.

2

@alqahtanimfar.c Welcome To Community

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

It will work dynamically

3

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.

4

Hi @alqahtanimfar.c ,

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

Regards
Balamurugan.S

5

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?

6

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

7

  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