Forum Discussion

amrita_singh's avatar
amrita_singh
New Contributor
11 years ago

How to compare pdf file to excel sheet

Hello there...



I have my application reports in excel sheet and pdf file. Now my requirement is I want compare my excel sheet reports to pdf file, I strucked with comparing these two files. My reports are in table format so I am unable identify the rows and columns in pdf. so please give some suggestions about this problem. My requirement is very very urgent.



Many thanks in advance......

1 Reply

  • Colin_McCrae's avatar
    Colin_McCrae
    Community Hero
    11 years ago
    Pretty simple ....



    They are totally different file types/formats. As far as I'm aware, you can't directly compare them.



    You'll need to extract the data from each and compare the two sets of data. You can extract text from a PDF - assuming it's not protected. You might need to do some clever manipulation of the extracted text in order to compare it to the same data extracted from an Excel sheet (which should be much easier to work with).



    I'm also not sure why you have this in the RIA section of the forum? Seems like a general functional question to me ....