Open PDF files based on specific excel values (Values are PDF FileName)

[Heisenberg]

Hi, i’m new to UiPath.

I have a folder consisting of PDF files.

I want to write the file name of each PDF file into an excel file. I will then use the values inputted inside excel file to check against a system.

The system will flag a outcome for each excel file name values, it will return either TRUE or FALSE. If the value is TRUE, i want UiPath to open the pdf file with that specific file name.

Please advise in modern activities if possible. Thanks!

[singh_sumit (Sumit Singh Tariyal)]

Hie @Heisenberg use these steps to get the files name from the folder one by one
and write the names in the excel

change the write line with write cell or write range
cheers Happy Automation

[Heisenberg]

Hi Sumit,

Thanks for relying.

What about opening specific pdf files in the folder based on the True/False value in excel for each file name?

[singh_sumit (Sumit Singh Tariyal)]

@Heisenberg for modern you can use this activities


click on the auto increament so bot is able to write into the next cell…
so this is your output looks like in excel

for next to read pdf use this

make your logic in inside if condition i just make a sample so you can uderstand the concept and logic

cheers Happy Automation

[Heisenberg]

Hi Sumit,

Thanks for your kind explanation. It worked.