RE: Export PDF tables to Excel?
From the Acrobat 6.0 (Professional) Help topic "Copying and pastingtables":
You can select and copy a table by dragging it to a spreadsheet application,
such as Microsoft Excel, copying it to the clipboard, or saving it to a file
that can then be loaded or imported to another application. If you have
a CSV-compliant application on your system, such as Excel, you can open
the selected table directly in the application.
To copy a table using the Select Table tool:
1. Select the Select Table tool . The tool is accessible via the Selection
toolbar.
2. Click in the table to select the entire table, or drag a box around the
rows and columns to be copied.
3. Do one of the following:
l To copy the table to an open document in another authoring
application, Ctrl-click (Windows) or Command-click (Mac OS), and
choose Copy Selected Table. Then paste the table into the open
document.
l To copy the table to a file, Ctrl-click (Windows) or Control-click
(Mac OS), and choose Save Selected Table As. Name the table,
select a location and the format, and click Save.
l To copy the table to a spreadsheet, Ctrl-click (Windows) or
Control-click (Mac OS), and choose Open Table in Spreadsheet.
Your CSV-compliant application, such as Excel, opens to a new
spreadsheet displaying the imported table.
l To use a document's tag information during table selection,
Ctrl-click (Windows) or Control-click (Mac OS), and choose
Select Table Uses Document Tags. This option is on by default
in tagged PDF documents. The option is grayed out if the
document is not a tagged PDF document. You can turn the
option off (if a document is poorly tagged, for example), to
override a document's tag information during table selection.
l To copy a table in RTF, drag the selected table into an open
document in the target application.
AFAIK, Acrobat 7.0 works much the same way. The feature
summary on PlanetPDF probably doesn't mention it because it
is not a new feature in Acrobat 7.0.
From: "Humphries, Ola" <Ola -dot- Humphries -at- energy -dot- sungard -dot- com>
Subject: Export PDF tables to Excel?
Date: Tue, 8 Mar 2005 14:41:22 -0600
We have had several occasions when we would have liked to export tables-as
tables--from a PDF document. These tables were originally done in Excel and
we would like to export them back into Excel for modification in that
application. Is this possible? www.planetpdf.com has a good summary of
Acrobat 7.0, but does not mention its export capabilities. We do not have
the source documents, but I think there is no problem with security
settings, as these documents have been furnished to us by our clients for
our own use.
Thanks.
Ola
Ola Humphries
Technical Writer
SUNGARD® Energy Systems
_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
WEBWORKS FINALDRAFT - EDIT AND REVIEW, REDEFINED
Accelerate the document lifecycle with full online discussions and unique feedback-management capabilities. Unlimited, efficient reviews for Word
and FrameMaker authors. Live, online demo:
http://www.webworks.com/techwr-l
Doc-To-Help 7.5 Professional: New version with new features, improved performance and reliability, plus much more! Download your free trial today at www.componentone.com/techwrlfeb.
---
You are currently subscribed to techwr-l as:
archiver -at- techwr-l -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- techwr-l -dot- com
Send administrative questions to lisa -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/techwhirl/ for more resources and info.
References:
Export PDF tables to Excel?: From: Humphries, Ola
Previous by Author:
RE: PDF Quirk
Next by Author:
Re: Help on Multipage Visio Into Word?
Previous by Thread:
Export PDF tables to Excel?
Next by Thread:
RE: Export PDF tables to Excel?
Search our Technical Writing Archives & Magazine
Visit TechWhirl's Other Sites
Sponsored Ads