Extract pdf table data into an Excel


#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 .


#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 …

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.


#10

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