Reading pdf data into excel

Help
,
1

Hi all,

I have data that mentioned below is present in 2 pdf’s. How to read that data from into excel.I’m new to this please help me.I tried but am not getting the results

Firstname : sundar
last name : sanju
phone : 8885728883

2

Hello @somas1218 try to use GetText activity and try to read required data.
once you get the data into a String then do string manipulations by using split functions…
when you get final output on a string after string manipulations then use write cell activity and post the data.

Hope my inputs are useful.

3

Hello there,

The world’s first open online training platform for RPA users.

Happy Automation,
Cheers :slight_smile:

4

The above data is present in pdf and what i want is left side of colon (i,e; First name,lastname) should come as columns in excel and right of colon should come as data into excel

5

use append a “,” if you don’t get from PDF.

6

Can you please create workflow and share it…it would be great if u help me

7

Pleas share your PDF

8
9

sundar.pdf (19.4 KB)

Please find the pdf. I have 2 pdf’s like that.Thank you

10

Hi @rkelchuri I’ve shared my pdf’s Can you please look into that

11

I am getting perfectly … please see this.

image
image786×346 12.2 KB

Please find your WFsomas1218.xaml (6.1 KB)

12

Thank you very much.But i asked for different thing. I’ve created a workflow which reads pdf and puts the data into excel.

13

Try to Open your default pdf reader with Open Application Or Start process.
Use Ocr For Extracting data.Then Build data table and Write it to Excel .Hope this soves your Scenario.

14

@rkelchuri
Try to Open your default pdf reader with Open Application Or Start process.
Use Ocr For Extracting data.Then Build data table and Write it to Excel .Hope this soves your Scenario.

15

Using OCR is like screen scrapping but i want to do using .Net functions .It’s working for me .i had done it