Frame Tables to Excel

[Art Campbell]

Save the Frame file, either intact or just the table fragments, as RTF
and open in in Excel?
You'd also have a path by PDFing it and saving the PDF out as RTF...

Art

On Jan 18, 2008 11:29 AM, Petersen, Oran C <oran.c.petersen at boeing.com> wrote:
> Howard Rauch <techtransfer at sbcglobal.net>
> Subject: Frame Files to Excel
> To: framers at lists.frameusers.com
> Message-ID: <467843.36684.qm at web82005.mail.mud.yahoo.com>
> Content-Type: text/plain; charset=us-ascii
>
> I have a client who has a pretty hot fire. I need to find a way to
> convert about 50 tables developed in FrameMaker to Excel spreadsheets.
> Does anyone have any suggestions?
>
> >From Oran Petersen
> Ans: I just opened a Frame file with 18 tables spanning 26 pages. I
> drag-selected the heading rows, which grabbed all of the body cells as
> well, did a standard copy, opened Excel, and pasted.
> I got a spreadsheet with each table column in an Excel column. Worked
> perfectly, took seconds.
> The caveat is that the Frame tables are considerably more capable than
> the Excel spreadsheet with respect to straddle and multiple paragraphs
> in one cell. Even those converted directly into Excel quite nicely
> within the limits of Excel. The issue is that multiple paragraphs in
> other than the left cell are pushed to the left cell, misaligning the
> data. This happens regardless of the format that you use (Frame, text,
> etc.) to build the spreadsheet. But if you have clean tables without
> straddles or multiple paragraphs per cell, copy/paste should work fine.
> I used Frame 7.1 and Excel 2003 for the test.
> Oran
> _______________________________________________
>
>


-- 
Art Campbell                                             art.campbell at gmail.com
  "... In my opinion, there's nothing in this world beats a '52 Vincent
               and a redheaded girl." -- Richard Thompson
                             No disclaimers apply.
                                     DoD 358