Copy data from Excel to PDF, read pdf text with OCR

Help Activities
, , ,
1

Hi,
I have a requirement where I have a set of Invoices, I need to copy certain data from Excel based on the Employee number and paste the Table into PDF at the bottom…
Please Help on this

Thanks

2

@MEGHA_cs,

Are you using any PDF editor, if not then try to filter the excel and create a new excel with the required data and format. Then save the new excel as PDF.

3

Thanks, But I need to append the data to Existing PDF,

4

try below steps

  1. using use excel file open the excel
  2. use copy/paste range set to clip board
  3. Open pdf document with word application
  4. use append text activity of word give empty input like “”
  5. use keyboard activity to paste the clip board value
  6. do save as pdf again

Regards

5

Thanks, Any other way we can copy the data directly in PDF

And I have one more issue, am getting error when using Tessaract OCR in Read PDF with OCR activity

image
image940×354 53 KB

Please help me with this

6

Hi,

The following post might help you.

Regards,

7

I want to use Read PDF with OCR activity

8

Hi,

It’s same cause of Tesseract OCR activity. It might be solved by same way.

Regards,

9

Thanks… its working

1 Like
10

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