If you are unable to edit your Excel Workbook after Exporting a PDF to Excel with PhantomPDF, follow the steps below.
PDF documents need to be searchable before they can be turned into editable Excel sheets.
- From the 'Save As' Windows when exporting to Excel
- Click on Settings...
- Select "Image-based document"
- Click OK and Save
PhantomPDF will run OCR on the PDF while converting it to Excel resulting in an Editable Excel Workbook.
Alternatively, you could perform OCR before Exporting to Excel, but this method does it all-at-once.