Extract data from excel datatable

Help
, , ,
1

data.xlsx (9.5 KB)

Hi All,

I have this excel sheet from which I have to extract the date from column 5 i.e. Operations and check if it’s greater than current date.
If it is more than 1 day of the current date then BOT will click approve in application.
Can anyone support in extracting the date from the sheet and compare it with current date?

1 Like
2

here you go with a sample xaml
hope its resolved
sowmy.zip (9.7 KB)

Cheers @somya177

3

@somya177,

Kindly check the attached workflow, I assumed to check with the first date and second date will be in the same date in each cell. so compared with the first date value form each cell.

ReadDateFromExcel.xaml (6.7 KB)