Read data from pdf and store that data into excel

Help Activities
, ,
21

@Swetha_V

If you can share your workflow I can make necessary changes…

22

Sequence1.xaml (13.1 KB) Data from PDF.xlsx (8.6 KB) CamScanner 03-11-2021 16.53_1.pdf (90.4 KB)
Please find the workflow, Pdf and excel file

23

Sequence1.xaml (15.7 KB)

  1. change the path with your path where you are saving the PDF attachments
  2. Add outlook email and save attachments because I removed it due to project version dependency
  3. Install PDF activities from UiPath Manage packages
24

Hi @Swetha_V - Adjusted the scaling factor to 2 and added the append range logic, so that when you drop multiple files in that folder, it will automatically write in the next row…

image
image1291×673 56.3 KB

Here is the xaml and files: Read_From_PDf.zip (125.1 KB)

25

Hello Pravin_Patil1,
It’s working but the problem is only extracting two words from the Pdf document (DO and NOT) remaining words not extracting. Can you help me with this?
Thanks in Advance…

26

@Swetha_V
Add one more assign after read pdf activity

image

27

Cap
same issue again

28

Ohh I thought you want only DO and NOT…

Then remove that assign I told you where we have split…

It works fine for me…

Just run the code as it is where we have used microsoft ocr…

image

29

@Swetha_V - you didn’t chk my xaml ?? :wink:

30

Thanks for your support

31

I have checked yours also it’s working. Thank you for your support…

32

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.