Using the save activity with a loop saving each file

Help Studio
, ,
1

I have a bot that extracts data from PDF files and writes it to a text file. Then, the text file is transferred to an Excel sheet. I would like to utilize the ‘For Each File in Folder’ loop to process multiple PDF files, writing their content to the text file and subsequently to the Excel sheet. Additionally, I want each Excel sheet to be saved with the name of the corresponding PDF file

2

@R_Wolff

Welcome to the community

Inside the loop currentfile.name will give the name of the file which can use used to create you text file and excel…

And currentfile.FullName will give the full location of the pdf files

Can you be specific if you are facing any issue in this?

Cheers

3

Hi,

Inside For Each,
Use Read PDF
Write To Text (To Format the data you could also use Generate Data table activity)
Excel Scope (Write Range to write the data)