Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X
What do I have to do to import an excel file into a proe pattern table?
We did this for some points that were places on a surface.
I think the procedure goes something like this:
To Read in data:
Here is a sample of what the data should look like:
!# Pro/TABLE
!#
! [] S 92;
! [] W 8;
![B] W 20;
![C] W 19;
![D] W 19;
![A] W 5;
"!"
"! Input placement dimensions and model name for each pattern member."
"! The model name is that of the pattern leader or any of its family table instances."
"! Indices start from 1. Each index has to be unique,"
"! but not necessarily sequential."
"! Use '*' for default value equal to the leader dimension and model name."
"! Rows beginning with '@' will be saved as comments."
"!"
"! Table name TABLE1."
"!"
"! idx" " d3118(65.806980300)" " d3119(137.7726490)" " d3120(7.205890390)"
1 43.987688909 137.7377847 21.767808765
2 29.980591370 234.5645454 4.298906330
3 34.455756455 136.5780585 12.454024500
Good luck
Paul
Thanks for your help
Bobby
you can add to your config file following parameter:
part_table_editor and set the value to excel...
This will allow you to edit pattern data in excel.
I usually create a separate excell file in which I do all the calculations, than copy and paste all the cells to the second tab (tab i created earlier) of the excel window opened up by pro-e. Cells that are going to be used for patter creation, I CUT and paste into first excel sheet.
I may have missuderstood your question, but I hope this was of some help....
I changed the parameter but nothing changed when I went to edit a table. It still came up with the proe editor. Did I miss something?
Check the option value to make sure it's still on excel... Also, save the config file after you change the option and make sure Pro_E is reading the config file you are changing.