sampledata.pdf (110.8 KB)
Actually i want to extract that table which is present in the above pdf…
Thanks,
paro…
sampledata.pdf (110.8 KB)
Actually i want to extract that table which is present in the above pdf…
Thanks,
paro…
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
Is there any pdf to excel activity present?
in which package it is present can u tell me?
Thanks,
Paro…
I guess there is one but I need to take a look. Give me some time I will let you know.
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…
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…
In Chrome as well?
yes
Thanks,
Paro…
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
Is this something you were looking for?
Thanks,
Meg
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?
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