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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

What do I have to do to import an excel file into a proe pattern table?

RobertMoore
1-Newbie

What do I have to do to import an excel file into a proe pattern table?

What do I have to do to import an excel file into a proe pattern table?


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
5 REPLIES 5

We did this for some points that were places on a surface.

I think the procedure goes something like this:

  • Place the first point independently on the part or surface.
  • Select that point and create a pattern table.
  • You can now directly edit the data or you can read in new data.
    • If you are working with excel data you will want to read in new data.

To Read in data:

  • In the Table editor window click save as.
  • A file will be created in the start in folder called table1_tmp.ptb (your system might be different (disclaimer )
  • Do not close the Pro table editor window.
  • Navigate to and open table1_tmp.ptb in wordpad.
  • Use excel to format the data as it is in the table1 file.
  • Paste the data into the file and save it back to the same name and location.
  • Back in the pro table editor - click: File -> Read and read in the edited data.
  • Finally click Save in the editor window.

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.

Top Tags