TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Subject:Re: how do you import an Excel spreadsheet? From:"Richard G. Combs" <richard -dot- combs -at- polycom -dot- com> To:"TECHWR-L" <techwr-l -at- lists -dot- techwr-l -dot- com> Date:Fri, 11 Feb 2005 15:23:54 -0700
Melissa wrote:
> In FrameMaker, how do you import an Excel spreadsheet with certain ROW and
> COLUMNS defined? (For example, I don't want to import all the blank rows,
> just a set of rows/columns.)
>
> What settings do you have to do in Excel first before attempting import?
> Do you have to first set the rows/columns to be the print area in the
> Excel spreadsheet? In FM, you then use Import -> Object -> Select from
> File, right?
Don't use OLE (Import Object). Set the spreadsheet up to print the way you
want it to look, print to PDF, and import the PDF (File>Import>File). Far
less overhead / file bloat / instability. And it's easy to get exactly the
layout/appearance you want.
Using OLE (linked or embedded object) doesn't usually make much sense in FM.
Its advantage is that OLE objects are "live," so they immediately reflect
changes in the "source" file. But you don't deliver FM docs -- there's
always a production process to go through -- so you inevitably capture their
state at some moment frozen in time. Might as well freeze the source doc in
time (by PDFing, exporting to PNG, etc.), too, and dispense with all the OLE
hassles.
HTH!
Richard
------
Richard G. Combs
Senior Technical Writer
Voyant, a division of Polycom, Inc.
richardDOTcombs AT polycomDOTcom
richardDOTcombs AT voyanttechDOTcom
303-223-5111
------
rgcombs AT freeDASHmarketDOTnet
303-777-0436
------
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.
