PDT table to Excel

Help
1

Hi,

I’m struggling to convert some data from a PDF to Excel. Here below a screen shot of data from a PDF that I have to upload to Excel. Any suggestion / comment would be welcome. It is not possible to use Uielement in the PDF. I have to use OCR. I tried to extract column by column with screen scraping but blanks values for an account are not catched.
screenshot

Thanks for your help.

1 Like
2

Hello,

I went through same scenario,
Check the pdftables.com they are providing API to convert PDF tables to excel.
Try and let me know, if you didn’t get I’ll upload my sequence.

Thanks,
Meg

3

if it is readable PDf then you can achieve by generate data table. providing tab as column separator and new line as new line separator

4

Hi Meg,

As I’m not very familiar with API’s, It would be very helpful for me if you could share your sequence :wink:

Thanks.

5

Hello,

Attached the flow, input your PDF with tables it will give the output test.csv
PDF2csv.xaml (8.1 KB)

Thanks,
Meg

6

Thanks Meg.
I tried to load the xaml but I have the below issue. Both OCR and PDF packages are installed. Do I need to install another package?

Issue

Thanks,
Laurent

7

Yes,
the missing activity is HTTP Request, so you have to install Uipath.web.activities packages.

8

Thanks a lot for your help. Unfortunately, for security reason, I cannot send HTTP Request.

Laurent

9

Not a viable solution, asking for 2/-Rs per page, that’s too much.

10

I guess you have first n free transactions.