I have a pretty interesting problem I’m working through. On this issue, I have an excel data table with a series of names and other fields. There is an empty column called “Gross Approval Limit” that needs to be filled with an amount. I am attaching a sample of this data table below.
Sample DT.xlsx (9.5 KB)
So the robot would need to open the excel file (with an excel application scope I presume), and for each row, look at the empty gross approval limit, open the corresponding PDF document to the Name listed on the document, screen scrape to OCR the number for the Gross Approval D&O, and import that number into the excel document row.
Does anyone know how this could be done?