Unable extract table data

Learn Academy Feedback
1

i have pdf file in that selector not working.i tried but i am unable to extract data to export to excel . from ORJ TO RECIEVER
can any help me …

pdf table data
pdf table data1366×1754 61.9 KB

2

In such cases, you have to read the entire pdf text and then apply string manipulation to convert it to datatable. Once data table is created, use write range activity to export the data into excel file.

1 Like
3

Hello Anand,
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