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.
-
Read above data from Excel file using Read Range activity and it will give output as DataTable. Let’s say dtInput.
-
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) Then Read pdf files and update the count and Ok column value as X row("Result") = pdfFilesCount row("OK") = "x" Else Nothing
-
Finally use Write Range activity and pass dtInput to write data back into Excel file.
i try, but it not working
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.