I need a program written which will parse a PDF document and pull requisite data from it into an excel sheet. I have attached an example sheet of the PDF report to this request. The yellow rows list the OPERATOR information, the white rows list the LOCATION information. The data from each LOCATION must be extracted (along with the OPERATOR information for the well/wells) and put into an excel sheet.
Identify first page of "L&O" report (noted with the text "1902 Locations by Operator" at the top
Create Excel sheet with the OPERATOR and LOCATION information for each LOCATION.
Excel Sheet with formatted data (example attached with 1 line of data)