Skip to main content
W
wfalco16-Pearl
16-Pearl
November 7, 2011
Question

Excel/WF4

  • November 7, 2011
  • 2 replies
  • 638 views
For those who do this a lot:

What method works well importing Excel into WF4?

Is there an impact using latest Excel?

Is there a link?

    2 replies

    W
    wfalco16-PearlAuthor
    16-Pearl
    November 7, 2011
    Clarification: I only need a simple table. Not using family tables, etc.
    So far I have imported a .csv and it works. But I know there were some
    tricks to changing the formatting once in. It comes in all black.


    W
    wfalco16-PearlAuthor
    16-Pearl
    November 8, 2011
    OK.

    In 4.0 I can import an Excel table (its a wiring list) as an object. Can
    even link it. However - its a dog to work with - colors and fills have
    to be addressed. I also see an issue (which I now remember from my past
    experience) of the table having a max width limit (unless it is known
    how to change it). The great thing is its linked.
    I chose another path.

    I saved the Excel as .csv. Inserted table from menu as a .csv. It turns
    it into a real Pro/E table. The down side is that it is not linked
    (unless there is a way). The upside is it comes in NICE (not &*%$%'n
    around). If you want to update the table from an excel - wash, rinse and
    repeat.

    I am happy with this for now.

    By the way - I am using Windows 7 (32 bit), WF4 and Office 2007.


    Terms & ConditionsCookie settingsAccessibility statement