Copy link to clipboard
Copied
Is it possible to automatically (or manually) update the contents of a table from a data source or by utilizing reference links to 3. party spreadsheet sources etc?
Copy link to clipboard
Copied
Yes. Open the spreadsheet. Copy the table. In FrameMaker click Paste Special / Linked Microsoft Excel Spreadsheet (or something - my dialogue is danish)
Copy link to clipboard
Copied
There are several options, one to avoid:
Copy link to clipboard
Copied
ExtendScript has a nice XML object so if the datasource is XML (or you can export it to XML), then scripting the updates could be a good option.
Copy link to clipboard
Copied
If using Excel, one other, albeit unsophisticated method, that works is importing by reference. You need to make sure there is only one worksheet in the Excel file and do all the formatting in Excel. You do end up with an empty paragraph return at the top of the table too. But it works.