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

The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.

Pattern Table getting data from external Excel file

Sandy1
9-Granite

Pattern Table getting data from external Excel file

Hi Everyone,

 

  • Have a hole which I want to make a pattern from (with angle as variable)
  • I want to use pattern table to do the pattern because I want custom entries
  • I can do that with no issue, but I want to make Creo get the data from an external excel file rather than internal protab. That way my boss can easily do part updates just by updating the excel file.
  • Say I want to create 5 holes at 0, 10, 15, 90, 270 degrees as an example.

Is that possible?

 

Thank you for your help.

 

Sandy

ACCEPTED SOLUTION

Accepted Solutions
tbraxton
22-Sapphire I
(To:Sandy1)

There is not provision to import pattern tables from Excel. It may be possible with some third party applications.

 

You can set up Creo to use Excel as the table editor but I gather you are looking to reference and external file (Excel) and use that to regenerate the model. Creo does not support this directly for a pattern table.

 

You may want to check out a company Nitro-CELL (simplifiedlogic.com) that deals with Excel integration with Creo.

========================================
Involute Development, LLC
Consulting Engineers
Specialists in Creo Parametric

View solution in original post

5 REPLIES 5
tbraxton
22-Sapphire I
(To:Sandy1)

There is not provision to import pattern tables from Excel. It may be possible with some third party applications.

 

You can set up Creo to use Excel as the table editor but I gather you are looking to reference and external file (Excel) and use that to regenerate the model. Creo does not support this directly for a pattern table.

 

You may want to check out a company Nitro-CELL (simplifiedlogic.com) that deals with Excel integration with Creo.

========================================
Involute Development, LLC
Consulting Engineers
Specialists in Creo Parametric
Sandy1
9-Granite
(To:tbraxton)

After doing some digging, unfortunately one cannot import pattern tables from external Excel. 

 

Third party solution like Nitro-CELL might be the solution.

 

Thxs everyone for your answer.

Chris3
21-Topaz I
(To:Sandy1)

I have not done this before but it may be possible to do this using an Excel analysis feature and setting the pattern variables to the Excel driven parameters

 

http://support.ptc.com/help/creo/creo_pma/usascii/index.html#page/model_analysis/bemod/To_Create_an_Excel_Analysis.html 

tbraxton
22-Sapphire I
(To:Chris3)

Excel analysis functionality is only available in the BMX module. So unless you have access to BMX that is not an option unless PTC has added Excel analysis functionality outside of BMX.

========================================
Involute Development, LLC
Consulting Engineers
Specialists in Creo Parametric
Sandy1
9-Granite
(To:tbraxton)

We have the standard Creo package, and we do have the Excel Analysis feature. However even with Excel Analysis, seems it cannot do the Pattern Table.

Announcements
NEW Creo+ Topics: Real-time Collaboration


Top Tags