To check if a column of a excel file in a folder contains specific keyword

I have a set of excel files in a folder and have to check a column called Verified, if it contains Yes then I have to continue with the process else stop. Can anyone help me with this. I have attached the file for reference as well

Condition For Entering Invoice to QB.xaml (15.2 KB)
Report 09-30-2022 15-17-43.xlsx (8.4 KB)

Excel file looks something like this

First get the files from the folder in to a list using directory.getfiles
Then loop that list and inside the loop use read range by giving current row value as file name.
Loop through the datatable and check if the currentrow(“Verified”).contains(“keyword”)
if yes means proceed else continue the iteration…
Thanks and Regards
Sreejith S S

1 Like

Thanks for your response!!

1 Like

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