Extract PDF table to excel

Help
1

Hi All,

I have a PDF file, which has content in tabular format. I need to exract this into an excel sheet.
Is there any way to automate this in UI path As I have multiple PDF files to extract like this.

Please advise.

2

Hi @SailuKrish

Welcome to the UiPath Community! We’re glad to have you here.

For your concern, please refer to this post:

Hope this helps.
Thanks and regards

3

Hello @SailuKrish,

You will need to use “Data Scraping” method which enables us to extract structured data from web application, document etc.

Thanks,
Pankaj

4

Datascariping is not working…

5

Please reply me…

Thanks,
Sailukrish

6

Please find the sample pdf format. Already used screen scraping and data scraping but I didn’t get required output.
Name date description time
Sass 10/01/2018 gfdyjhf 8.00
Ffdyjj
Gfhhh
Kkkk 15/02/2018 jtesgyjj 7.00
Gggh
High 18/03/2018 ghjjkkh 4.00

7

Hi @SailuKrish
Is ffdyjj and Gfhhh names?
Then they do not have date, description and time? :slight_smile:

8

No.It’s a description, that is in multiple lines…

Thanks,
Sailukrish

9

So what you need are those 3 lines with complete details? :slight_smile:

10

Yes… I need to extract entire table it has number of records like this… Already i used read pdf with ocr text and I get entire pdf data is stored in string variable. After that what can I do to retrieve the table data to excel.
Thanks,
Sailukrish

11

Use regular expression