Pattern Table getting data from external Excel file

[Sandy1]

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

[tbraxton · Accepted solution]

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.

[Sandy1]

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]

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]

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.

[Sandy1]

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.