Extract pdf table data into an Excel

Help
1

Hi All,

I am new to UiPath and working on a project where i have to extract table data from pdf to excel. I have tried using Data scrapping and screen scrapping options as well but i could not get the output .

I have gone through similar articles in forum .

But i could not understand the logic.

Can someone help me out to implement the logic in simpler manner .

Attaching the sample PDF for your reference .

sampledata.pdf (110.8 KB)

Much appreciated your kind help and support .

Thanks again .

2

What you want to extract in this PDF.?

3

I would like extract table data from the PDF .

Attached screenshot for your reference .

image
image1019Ă—567 23.9 KB

4

Main.xaml (11.4 KB)
Hi please find the solution here we have 5 array with speed, driver, car, engine and Date and there is a build data table, all you need is loop each array and add data to data table.

5

Hi Divya,
I want to get the data into CSV in a tabular format.

Currently i tried with excel but i got all the data in single cell. Attached the sheet for your reference.

sample.xls (8.8 KB)

6

if you create a proper data table you can write it to either excel or to csv that doesnt matter

7

Hi Sailaja,
Main (1).xaml (17.6 KB)
As per your requirement to store in both excel and csv.

Thanks’
Venkatesh

8

Thank you . I am able to extract data from the sample PDF attached .

But i am unable to extract from other PDF . Have changed all row columns and variables according to other pdf. Could you please help me out on this?

TURBO COOLING SYSTEM WE MEAN COOLING_1.pdf (132.0 KB)

Attaching the PDF .

9

Would like to extract this …

Capture1
Capture11047Ă—197 9.89 KB

I have changed the substring values according to the data in the PDF . I am only able to extract Required content not column wise.

Please help out on this.

Appreciate your kind help and support.

1 Like
10

How can we Extract Data from a Table in PDF if we are not aware of the number of rows.

1 Like
11

Hii, i have a pdf which has scanned image in table format
how i extract the data from pdf and store in excel
i tried uisng ocr but the extracted output are store in a single cell without alignment can u suggest the solution if possible
i attached my sample pdf file sample…pdf (433.0 KB)

12

I have similar requirement and tried your attached solution but it give me “Missing or invalid activity”. please let me what i am missing.

1 Like
13

Try to update and install all available packages.

1 Like
14

Thanks it worked after package installation. I need to pick data from insurance certificates which are from different insurance companies in different formats. please help which approach should I go.

15

Hello,

I have the same trouble, but I am unable to loop through the arrays to get all the information in the different rows. How should I do this? I attached a photo of the pdf as I wasn’t able to upload it.

Thanks in advance!

image

16

@Divyashreem, I am unable to extract table data from the attached pdf if I use your work flow. please help…FFF417A5
A quick help is appreciated…

1 Like
17

Hi,
to be frank i have no clue which workflow you are using for this, Can you please elaborate the steps?

Thank you,
Divya

1 Like
18

Hi ,
The One you have shared in the previous postsMain (1) (1).xaml (14.9 KB).

We are using The attached PDF in your workflow. but it is not working859654-Mr-Graham-H-Smith.pdf (43.1 KB)

Thankyou
Smaily

1 Like
19

Read PDF Text→Substring→Split string(output is an array)→Generate Data Table(input: array(0), ColumnSeparators: " ", output: dt)→write range
It’s work for writting first row to excel, use for each, to write all row.

20

My I know which package you have installed/updated because I am also facing the same problem.

1 Like