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
Thanks for your response!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.