How to extract table from pdf

sampledata.pdf (110.8 KB)

Actually i want to extract that table which is present in the above pdf…

Thanks,
paro…:slight_smile:

You can go through this thread:


Hope it helps else there is one workaround “You can use google chrome to open the pdf then use Data Scraping to do that”.
There is one more way you can do that but lets try these first.

Thanks!
Anmol

1 Like

Is there any pdf to excel activity present?
in which package it is present can u tell me?

Thanks,
Paro…:slight_smile:

1 Like

I guess there is one but I need to take a look. Give me some time I will let you know.

Hey @parvati,

Go through this thread.

you will find all the answer in here.

Thanks!
Anmol

Thanks,
but it seems very long processs,
there is one activity which directly extract the tabular data and save into the excel…
i want to go through by tht activity…
if you know in which package it is present?
can u please tell me?

Thanks,
Paro…:slight_smile:

There is no direct activity to do that. Only shortcut to do that open it in Chrome then use “Data Scraping” or change the adobe reader version accordingly go through the previous thread.

Thanks1

but data scaping is not working?

Thanks,
paro…:slight_smile:

In Chrome as well?

yes

Thanks,
Paro…:slight_smile:

@parvati, Try this packagePDF2Excel 1.0.0.nupkg (3.9 KB)

1 Like

Try this flow, Data Scraping is working in my case.
Main.xaml (7.7 KB)

For data scrapping to work on PDF, there are few settings to do in PDF reader,

please refer the below thread for more info onn PDF Selectors.

Thanks,
Meg

1 Like

Is this something you were looking for?

Thanks,
Meg

1 Like

image [quote=“Rashmi, post:16, topic:97730, full:true”]
Try this flow, Data Scraping is working in my case.
Main.xaml (7.7 KB)
[/quote]

hi rasmi can you pls help me with this

Hello ,
Have you try to open the PDF on adobe reader and try the data scrapping?

I tried but not working. @vmariejeanne

Hi Parvati,
Did you manage scrape only tabular data from this PDF?

Please share the pdf as well it will be helpful for me.

Regards
Abhijeet Ashish

Hello
In this video, I extract tables from PDF and write data in Excel:

0:25 Install PDF Activities
1:10 READ PDF text, Get PDF page count, Extract PDF
5:40 Read PDF with OCR
6:55 Join PDF and Manage PDF passwords
9:30 Extract Images From PDF and Export PDF as Image
12:00 Extract table from PDF use-cases 1 replace some spaces with | (one column has multiple words)
24:00 Run the robot to see the result
25:40 Extract Table from other PDF use-cases 2 delimiter is 2*spaces " " easy split
31:50 Extract Table from complex PDF use-cases 3 unstructured data the logic will be based on IsUpper and IsLower
40:25 Extract the price value from PDF

Thanks,
Cristian Negulescu

1 Like