How to copy data from excel & search it in a PDF?


#1

Hi ,

I want to copy data from different columns of an excel sheet (Single Row), & want to search that data in a PDF file.

Want to display an output that everything copied from excel matches the PDF content


#2

Use read cell activity to get data from cell, then use open application and hotkeys activity to open pdf file and search.


#3

Read the pdf as a string. After that iterate a loop of the excel table

and put the values in StringVariable.Contains(“ExcelcellValue”)