Extract Data from pdf into excel workbooks

Help Studio
, ,
1

I have a personal project at hand, I stored 10 pdfs in 1 folder and looped through them to get text but now I want create a separate excel for each pdf with the name of excel as the invoice number extracted from pdf I have done the extraction part please help me with next steps.

2

hi @Pratik_Mahajan ,

Welcome to the UiPath Community!

So you’re looping through all the pdfs and able to extract the invoice number as well.
Inside the same loop use a Write Range activity, in which you can give the invoice number as file name and write the data in that excel file.

So at the end of workflow you’ll be able to see 10 excel files with data extracted from 10 pdf files with name as invoicenumber.xlsx.

Regards,
Aditya

3

I have a template excel file where i have to write these values in a particular field, so is that possible with this activity?

4

Yes, take a copy of the template file, save it with the invoice no and write results to the new copied file. Place these steps inside the loop so bot copies template file for each pdf and generate output excels.

5

Hi @Pratik_Mahajan ,

Yes it is possible.
Just in the starting of the loop you’ll have to create a copy from the template file using Copy File activity and giving source and destination file paths.
And then you can place the values where it is needed.
If it has to start from a particular cell, just give the range in Write Range activity.
or else
If the data to be written is at different positions, you might have to use a write cell activity.

Thanks,
Aditya