Microsoft Office Tutorials and References
In Depth Information
Loading PDF Data to Excel by Using Able2Extract
Figure 5.12.
Figure 5.12. Jon Peltier simplifies the creation process for several unusu-
Jon Peltier simplifies the creation process for several unusu-
al chart types.
al chart types.
Note
You can read more about Jon s add-in at http://peltiertech.com/Util-
ity/ .
Loading PDF Data to Excel by Using Able2Extract
Loading PDF Data to Excel by Using Able2Extract
People love sending data in PDF files. Now that Microsoft is providing a
PDF-creation utility, more and more documents will be emailed via PDF.
The authors of PDF documents often use PDF format to ensure that the data
cannot be altered. Other times, the authors want to make sure that someone
who does not have Excel can still view the data. Although these are fine
ideas, getting data back out of PDF and into Excel is very difficult.
Note
You can download a free trial version of Able2Extract from
www.investintech.com/able2extract.html .
Data copied and pasted from PDF to Excel usually loses its columnar
format. Able2Extract solves this problem. You simply open a PDF file in
Able2Extract, and you can convert the contained data to Excel with one click.
If you need absolute control, you can specify regions so that, for example,
titles and headers beyond page 1 are not imported.
In some PDF files, the entire document is a scanned image of the original file.
The Professional version of Able2Extract can even deal with these.
Search JabSto ::




Custom Search