Export PDF to ExcelProblems I use Export PDF to convert a public PDF into an Excel XLSX spreadsheet. There are two problems with the conver
Export PDF to ExcelProblems
I use Export PDF to convert a public PDF into an Excel XLSX spreadsheet.
The PDF file is ENR 4.4 NAME-CODE DESIGNATORS FOR SIGNIFICANT POINTS EGENR44en2019-05-23.pdf (attached)
The XLSX file is ENR 4.4 NAME-CODE DESIGNATORS FOR SIGNIFICANT POINTS EGENR44en2019-05-23.xlsx (attached)
The PDF file is a table with 4 columns and approx 50 data rows per page for a total of approx 950 rows.
Both files can be navigated by looking at the unique key which is the first column of each data row.
There are two problems with the conversion.
(1) Some of the PDF page headers are not exported.
Look below the data row with key ARNUN - the page headers that should follow are missing only the column headers are present.
Compare that with the data row BEDEK which is followed by both page headers and column headers.
(2) The PDF has a second column of geodetic data.
Most of the XLSX keeps the data (correctly) as a single column but some rows split the data into separate latitude/longitude columns.
Look at the page of data rows CALDA to DOLAS - the geodetic data is split into separate latitude/longitude columns.
Compare that with the page of data rows ABAPO to ARNUN where the geodetic data remains a single column - and this is true for most pages.