Skip to main content
S
Sandy11-Visitor
1-Visitor
September 1, 2021
Solved

Pattern Table getting data from external Excel file

  • September 1, 2021
  • 2 replies
  • 3150 views

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

Best answer by tbraxton

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.

2 replies

tbraxton
22-Sapphire II
tbraxton22-Sapphire IIAnswer
22-Sapphire II
September 1, 2021

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.

S
Sandy11-VisitorAuthor
1-Visitor
September 8, 2021

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
Chris321-Topaz I
21-Topaz I
September 1, 2021

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 II
tbraxton22-Sapphire II
22-Sapphire II
September 1, 2021

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.

S
Sandy11-VisitorAuthor
1-Visitor
September 1, 2021

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.

Terms & ConditionsAccessibility statement