cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

Excel/WF4

wfalco
15-Moonstone

Excel/WF4

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 2
wfalco
15-Moonstone
(To:wfalco)

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.


wfalco
15-Moonstone
(To:wfalco)

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.


Announcements
Business Continuity with Creo: Learn more about it here.

Top Tags