Extract data from excel datatable

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

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

Cheers @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)