I want to compare pdf file data and excel file data and if that data is matched need to update the status column in excel file. Can anyone help me.
what type of data from PDF do you want to compare? How do you extract it from PDF?
I want to compare the account no which is present in excel as well as in pdf. If data is matched then status column should get updated in excel file.
Does this account number have any specific format?
I’d suggest to extract the text from PDF and the use RegEx to extract Account No. Once it’s done you can compare these values.