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 ...
Forum Discussion
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 ....
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 ....