Copy link to clipboard
Copied
Hello Everyone,
I have a format for a table which the border of the header and the end of the table is bold boder.
When i manually input for the table with little row into FM the format is no problem.
However, we have some tables that have a lot of rows so inputting each row into FM is a terrible job.
I also tried copying the table from excel but that lost the original properties of the table (e.g. table border)
So how to inputing the table have a lot of rows into Framemaker while keeping the original format of the table in Framemaker, and at the saving time?
Copy link to clipboard
Copied
Hi,
You can create your table in Excel and paste this table as text without formatting (Edit | Paste Special). Then select all this text and convert it into a table (Table | Convert to Table).
This works only, when there is only a single paragraph in each table cell.
Best regards
Winfried
Copy link to clipboard
Copied
Thank so much.
It's really helpful for me.
Copy link to clipboard
Copied
You can also export from Excel to PDF, and import that.
If FM doesn't need to access or reference table content, the PDF route has a lot of advantages.
Be sure to assign some asset ID so future document stewards know where the PDF came from. I used to use above- and/or below-table rows content that was clipped by the Anchored Frame.
Copy link to clipboard
Copied
Sounds like the table designs have an override regarding the thick line below the heading. I would recommend you buy Frameexperts small utility "Table Cleaner". It has save me lots of hours fixing tables!
https://frameexpert.com/store/index.html
Copy link to clipboard
Copied
When I have complex data in Excel, I like to save it as a tab-delimited or csv file, then import into Frame. Frame will give you the option to convert the data to a table, apply a table style, and apply header/footer rows.