Read all PDF files from folder

[Tesla (Siarhei Fralou)]

I have a process in which reading PDF document and writing it in the xlsx file. How I can substitute the PDF file to list PDF?

[Susana (Susana González Cacheiro)]

Hello @Tesla,

Hope this could help you,there is an example of looping files in Library pane. Library pane shows a list of folders containing workflows. Any workflow from Library can be added to a workflow by dragging and dropping it into the designer workspace, just like any activity.

Take a look at this:

Looping through files

James Reece June 14, 2016 09:38 ANSWERED I want a simple workflow to open a pre-defined folder location and to iterate through all pdf files within that have a similar filename (the date changes), e.g. “Weekly Macro Report_yyyy_MMM_dd”, and perform some screen scraping. How can I express "Weekly Macro Report * " as a variable to the Read PDF activity. A wildcard, basically. I cannot find documentation that details the parameters/variables of the activities.

Read multiple pdf files from a folder

I am new to uipath and creating my first sample project where I would like to read multiple fields from multiple pdf files. I have started by using select folder, extracting the file paths using Directory.GetFiles. Then I read each item in the list of files i get. How do i perform the get text for reading a particular field from all the pdfs and storing it in an excel. Kindly help.

Studio - Using Arguments

Regards,
Susana

[hojoong.kim (HJ Kim)]

@Tesla I’ve just created a sample code for you and it’s almost same as @Susana has shared the info above.
Test_ReadPdfFiles.xaml (8.5 KB)

Cheers!

[Tesla (Siarhei Fralou)]

Thank you for much!!!

[sjawadaf (M.Jawad Shirzai)]

thank you for the template, but i want to open each pdf file, inorder to extract(read) the invoice number, invoice receiver and the sum. It is only possible if i can open the each pdf files. I can open just one pdf with double click activity. Is there any other solution to open each pdf file ?

[Tesla (Siarhei Fralou)]

Hi @sjawadaf. For you case i have used OCR activity and were get data table. The next step is get need invoices from data table.

[Smith93 (Di3sel)]

Wow! My mind is blown. I have been using UIPath for a while now (4-5 months) and I did not even know about the Snippet code examples. Thank you

[tiruraj89 (Tirupathiraju)]

Hi all,
can you help me, while i am doing extraction text from multiple PDF file, which are in same folder. but i am unable to do that. plz can any one share link for that.

Regards,
Tiruraj

[sreekanth]

@tiruraj89, Select the library which is beside activities panel and then snippets,In the Loops You find for each file in a folder, give your folder path.Use open application (or) start process and give your pdf reader.exe path and pass the pdf file argument which you extracted from for loop and change the selector to dynamic to execute multiple pdf’s.

Thanks,
Sreekanth.k

[tiruraj89 (Tirupathiraju)]

Thanks Sreekanth.

[Jayesh_678 (Jayesh)]

Hi,
I am creating a folder by "sender_mail_address / mail_date " .
In Mail date subfolder I save the PDF attachment.
I want to read that PDF name.
Can you please give me suggestions?

[ClaytonM]

See reply here:

How to get the exact file names?

oh ok. So you can use Directory.GetFiles() to get all files in that folder, whether it’s one file or not, it will still give you a list of files. But, you can hardcode the index as 0 if you only want to do the first one it finds. I don’t recommend using local locations for data storage, unless it’s strictly for attended. But, I’ll use your path as a variable. Example shown below: srcPath = "D:/ Mail_addaress /current_date" srcFiles <Array Of Strings> = System.IO.Directory.GetFiles(srcPath, "*…

Setting close timer because this question is duplicated. @Jayesh_678 please avoid posting duplicate questions in multiple topics, and if it’s not related to the original post in the topic and you can’t find an answer by searching, then create a new topic.