Skip to main content
Known Participant
July 10, 2014
Question

How to import a table from an excel for word into an fm file?

  • July 10, 2014
  • 3 replies
  • 402 views

Is there any shortcut?

This topic has been closed for replies.

3 replies

Arnis Gubins
Inspiring
July 10, 2014

<esc> f i f

Known Participant
September 4, 2014

I tried the menu button Import>Object>Create New>Microsoft Excel Worksheet, but because my fm is structured, what I import from the excel is in red in the structured view tree.

Legend
September 4, 2014

All table components in structured FM must be wrapped in elements. If you paste in a table, the elements will be created automatically and use default names, which are likely to be different than defined in the underlying EDD. So, the element tags show in red. You need to either change them all manually or use some kind of scripting. There is no automatic method, unless you use a plugin.

You can speed things up by using the Find dialog. It can search for an element tag and replace it with another. You have to do one tag at a time.

Russ