Skip to main content
Sep 1, 2021 7:22 AM UTC
Solved

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

tbraxtonAnswer
Sep 1, 2021 1:29 PM UTC

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.

5 replies

tbraxtonAnswer
Sep 1, 2021 1:29 PM UTC

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.

Sandy1Author
Sep 8, 2021 12:19 AM UTC

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.

Sep 1, 2021 1:38 PM UTC

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 

Sep 1, 2021 1:43 PM UTC

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.

Sandy1Author
Sep 1, 2021 11:08 PM UTC

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.