How to add a string variable in empty excel row

Hi,

I have a folder full of pdf files. I need to read the names of files and check if they already exist in excel and if isn’t exist I need to write the name in a new row in A column. How to do that.
I try some ways but isn’t good.

readDataFromTxt.xaml (25.6 KB)

Get the files names from the folder and store it in a variable. cross walkthrough the excel . if it exists dont add it else add it in the excel

@JOHOHO Is there any particular reason you are using Excel Application Scope Instead of WorkBook Read Range?