From MS Excel, how can I import 10 Cells into the Framemaker Table, where I already have 10 empty cells.
Also, is it possible to copy multiple Rows or Columns from MS Excel (or MS Word) into the Framemaker?
Unless matters have changed in later versions, table import in FM is weak to non-existent.
What I do is
For extra credit have some cells above or below the rows of interest provide some provenance information (file path/name, date) and crop that info with the anchored frame in FM. This gives future document stewards some track-back information when the published table needs to be updated.
…having had to work with FM files where the tables were raster screenshots providing zero clue as to where they came from…
Thanks for your response,
Can we just copy 5 cells from Excel file into the 5 cells of the Framemaker???
I do understand your point, Table (or even Table Cells) copy into the FM is not simple cut/paste deal.
Once again, thank you.
You can copy and paste cells from Excel into a FrameMaker paragraph, to create a new FrameMaker table containing those cells. You can then copy those cells from the new FrameMaker table into an existing FrameMaker table and delete the new table. In particular, in Excel, copy the desired cells. Then, in the FM paragraph, use Edit > Paste Special to paste the cells as Rich Text Format.
When I copy some Excel cells and paste them into a FM file, the text is there.
The columns are separated by tabs. The rows are separate paragraphs.
Select these paragraphs. In the Table menu click on Convert to Table to create a FM file.
Then copy the cells/rows from the table and paste them into your existing table.
Thanks Lynne, Winfried, Bob.
I understand there is no easy way around copying Table from Excel (or Word) into Framemaker.
But solution is easy enough. I have tried Lynne's suggestion; I will try other as well.
It does work.
Appreciate your help.