How i can check if array row (Add Data Row) like name, surename and age exist is excel sheet.
What i am doing:
Reading some data from PDF file like: name, surename, age
I store these data in Array row data table (dtOutput) variable
And now in for each loop what type of condtition i have to use to compare these stored data with data which are existing i excel sheet
for each (condition?)
if true → do nothing (or other activities like ad in separate sheet)
if false → add data to excel under new row
Please help. Cheers!