Microsoft Excel to FrameMaker Conversion

Subject: Microsoft Excel to FrameMaker Conversion
From: <classe -at- charter -dot- net>
To: "TECHWR-L" <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Mon, 2 May 2005 20:54:56 -0400


I have imported a Microsoft Excel worksheet into FrameMaker. The data in
the worksheet is in one column (13 items of data separated by a blank row -
there are many sets of 13 items of data) in Microsoft Excel. When I import
it into FrameMaker, the data is imported as one large continuous table with
a blank row between each 13 items of data. I would like FrameMaker to format
the data into individual tables, rather than one continuous table, as I need
to add text and headings between the data. If this cannot be done, is there
a way to change the blank row inside the table from a Cell Body style into a
Body style outside the table, as this may help in placing the text and
headings between the tables. Has anyone attempted to do anything like
this?

In answering my own question, I wrote a macro to place each of the 13 items
of data into a separate Microsoft Excel sheet. When all the sheets are
imported into FrameMaker, each sheet is created as a separate table. All I
have to do is format the tables and it works fine.

.......

Ed Soomre
Contract Technical Writer
EMC Corporation
Hopkinton, MA



^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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

---
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.



Previous by Author: Scroll Wheel Use on Logitech Mouse using FrameMaker 7
Next by Author: RE: First usage question (are we wrong?)
Previous by Thread: RE: Scroll Wheel Use on Logitech Mouse using FrameMaker 7
Next by Thread: List archive issues


What this post helpful? Share it with friends and colleagues:


Sponsored Ads