Speeding up the PDF to Excel Conversion with the Able2Extract PDF to Excel Conversion Feature
Users may frequently encounter the need to convert PDF documents
containing a large number of pages (eg. 500+). While the speed of
Able2Extract's PDF to Excel conversion is very good, conversion will inevitably
take a little more time when a large number of pages are being processed.
Here are a few quick tips to speed up
conversion:
Turn off the "Excel Fonts" Option in the View Menu The Excel Fonts command turns on/off
excel fonts for the to-Excel conversion. When turned on (which is the default
setting), this feature attempts to replicate the size, colour and type of font
from the PDF in Excel.
When turned off, the standard excel font is used. As such, Able2Extract spends less time attempting to replicate the fonts found
in the PDF document.
Turn off the "Excel
Spacing" Option in the View Menu
The Excel Spacing command turns on/off
the automatic spacing for the to-Excel conversion. Turning this option off in
addition to turning off the Excel Fonts will speed up conversion.
Excel Spreadsheet Limitation
Excel spreadsheets contain only 65,000 rows. In cases of very
large PDF documents that require conversion from PDF to Excel, it is possible
that the number of rows in Excel could be exceeded. This may cause Excel to
crash or freeze. In this case, it is suggested that the to Excel conversion take
place in two or three parts. This will ensure that the 65,000 row limit is not
exceeded.