I need to fetch a particular data(Balance Due) from pdf files and compare the same with a column (Balance due) in excel.
Though the PDF file will be in same format, but positioning of the field Balance due may differ depending on number of invoice lines,etc.
How do i make my bot understand to fetch only that data which is balance Due??
Say my invoice looks like this, and I need to fetch the balance due amount for multiple pdf files:
I am trying the reconcile the pdf data with excel file data.
Fetch balance due amount from PDF and compare it with Excel data file.