Help :)

I have this Excel spreadsheet here, I wanted to count the PDF files from Ordnen, but only those I haven’t already counted and there is an x in the “Ok” column, otherwise I wanted to count the others and enter x.


  1. Read above data from Excel file using Read Range activity and it will give output as DataTable. Let’s say dtInput.

  2. And then use For Each Row activity to iterate one by one row.

    For Each row in dtInput
       If String.IsNullOrEmpty(row("OK").ToString.Trim)
             Read pdf files and update the count and Ok column value as X
              row("Result") = pdfFilesCount
              row("OK") = "x"
  3. Finally use Write Range activity and pass dtInput to write data back into Excel file.

i try, but it not working :frowning:

@momo10 Could you let us know what was the Issue faced?

i have a task, and i have to create a robot, which copies the folder names from excel table and searches in desktop, and has to count all pdf files(With different names) in the folder, and write again in excel table, but when the column “OK” is full, the robot has to skip row and count the next row.

@momo10 , What was the issue you faced while following the Steps mentioned by @lakshman

The Steps mentioned should work.

Any errors you recieved? If so, Could you Post the Screenshots of the Error ?