How to extract table from pdf

[parvati (parvati thalal)]

hello everyone,
can anyone help me for this
how to extract table data from pdf file?

Thanks,
paro…

[anmolk171 (Anmol Kumar)]

Hi @parvati,

You can use Data Scraping to do that.

Thanks!
Anmol

[parvati (parvati thalal)]

Thanks for your response,
but it is not working…tell me some other way to extract the table,
is there any activity for that?

Thanks and Regards,
Paro…

[anmolk171 (Anmol Kumar)]

Can you please send me the PDF or xaml file?

[parvati (parvati thalal)]

sampledata.pdf (110.8 KB)

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

Thanks,
paro…

[anmolk171 (Anmol Kumar)]

You can go through this thread:

No labels when trying to use Find Element in PDFs [Solved]

I’m am following the course “Level 1 - Foundation Training”. I’m at Lesson 10 - Practice 1. When I try to do as told in the exercise: “Attach to the PDF Reader window using an Attach Window activity.” “Drag an Anchor Base container inside the Do block:” “on the left side, we’ll drag a Find Element activity to select our anchor.” “we click Indicate on screen.” “we click the DATE label next to the actual date we are trying to get.” I am expected to get the following result: (New users can o…

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

[parvati (parvati thalal)]

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

Thanks,
Paro…

[anmolk171 (Anmol Kumar)]

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

[anmolk171 (Anmol Kumar)]

Hey @parvati,

Go through this thread.

How to convert Pdf file to excel and save in one location?

Hi @arivu96 [image] i gave filename as untiled But here two files is there like that see the file type too that is also difference? In Microsoft Excel Worksheet in that there is No Data [i created this one only] In Microsoft Excel Comma Separated Values File in that there is a Actual Data [All Data] [image] Hi @arivu96 Are you there ? see the previous post and this post to to queries ? we can able to do the further changes in that xaml file for my requirements can you please help m…

you will find all the answer in here.

Thanks!
Anmol

[parvati (parvati thalal)]

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…

[anmolk171 (Anmol Kumar)]

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

[parvati (parvati thalal)]

but data scaping is not working?

Thanks,
paro…

[anmolk171 (Anmol Kumar)]

@parvati

Thanks,
paro…

In Chrome as well?

[parvati (parvati thalal)]

yes

Thanks,
Paro…

[ak3430 (Anil Kumar)]

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

[Rashmi (Rashmi Pareek)]

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

[megharajky (Megharaj Yadravi)]

@Rashmi

Try this flow, Data Scraping is working in my case.

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.

Selecting PDF Elements

Hello, I am new to UiPath and have been watching all the tutorial and playing around. I have the latest community version 2016.2.6274 I am having issues trying to select elements in PDF documents. These documents are native and do not need OCR. I can read the full document text, but I cannot use the screen scrapping method to select individual elements (it only select the full document). I have a feeling it may be something to do with the accessibility settings in adobe reader DC, I have tried…

Thanks,
Meg

[megharajky (Megharaj Yadravi)]

Is this something you were looking for?

Pdf to excel activity

use this link RPA Listings - Collections, Integration Packs | UiPath Marketplace and downloaded [image] like this and place int the C:\Program Files (x86)\UiPath\Studio\Packages and install the package [image] and refresh then u can able to see [image]

Thanks,
Meg

[syed1994 (syed)]

[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

[vmariejeanne (Vincent Mariejeanne)]

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