How to use Excel spreadsheet to control dimensions?

[izukama]

Hello there,



May i know the concise steps to achieve the above? I suspect that PRO/E allows me to generate a part using a three dimensional equation, can anyone pls tell me how to do that? thanks!!

 

[xcad]

hello



one quick and easy way is through Family tables.

Create the generic part, then create a family table, choose the dimensions you want to change for the columns of the table.

Then click File > Edit with Excel, from there you can edit your instances.

I think there is no easy way to link a *.prt, *.asm file directly with a *.xls file, so you must work with the above option



xcad

 

[proed]

I can't tell from your question if this is what you're looking for - but here's a way to drive a Pro/E model from a spreadsheet - documented with steps & screenshots:



http://www.profilesmagazine.com/p22/tips_muirhead.html



Ed

 

[xcad]

hello



have any of proe users tried the above method of the described site ??

I felt that i had to discover the wheel again.....

Why PTC has an excellent way sometimes to make easy thinks so difficult ??

Well... lets hope wildfire would be more windows cad system



xcad

 

[izukama]

Thanks for the help, proed and xcad. you guys have given me the best Christmas present ever!! may God bless you guys in all endeavours. )

 

[izukama]

Hello xcad,



How do i update the values in the family tab tables after i have modify them?



Also, how to change from column to row format in the Family Tab table? i got 60 variables and quite hard to see them in col format...



Thanks.

 

[xcad]

hello



File > Update ProE



did you try this ?



xcad

 

[izukama]

Dear xcad,



i did as u instructed in Excel to update Pro/E. But when i close the spreadsheet, and i use Regenerate in the command list, it said that pro/e has not changed since last generation!! Please advise....Thanks.

 

[izukama]

Dear xcad,



Why does Pro/E generate a new tmp file every time i use Excel to edit the dimensions? It seems to work the lst time, but File --> Update Pro/E does not seem to work the second time and subsquent time....Pls advise....This is a matter of life and death....