I have a model that is controlled by 45 parameters. I want to be able to control the parameters from an excel spreadsheet. The reason for doing this because the parameters sheet is tedious to change values and make updates. It will also be easier for individuals without a lot of Creo experience to use the program.
Please let me know if there is a way to do this.
Have you considered creating a drawing with a table containing the parameter values? Double clicking on parameter values in a table allows you to edit them. You can use a repeat region to pull all the parameters from your model then manually filter out the ones you don't want to see. Or, if they all have a common naming convention like a prefix or suffix, you can write a repeat region filter to pull only those you want.
This would make it nearly Excel easy but still within the Creo environment.
Just for controlling parameters you may try an Excel analysis. Watch this video below:
It´s not in English, but it´s easy learn from it.
For more complex jobs, maybe some programming: VB,J-Link or Toolkit.
Another alternative is addon called SmartAssembly:
I think that the excel analysis will work the best for what I am trying to do. I am having an issue with the link to the excel file though. When I originally setup the file I could get it to update the parameters. However, once I close the spreadsheet and try to reopen the model the link seems to be broken. I can open up the file and modify it but the parameters do not seem to update.
I found your question, while looking for something similar (I have a lot of text boxes which my boss frequently requests I change the wording on.) While I read your question, I had a brainwave. If you (and I) pull all the parameters we want to control with excel into a family table, we can click the "Edit the current table using Excel" button and just copy and paste the new values from our spreadsheet. (It would be nice if we could keep the spreadsheet in the family table, but I've found that Creo strips out the formulas and other tricks, so that is a no go.) It is a long setup, but it would pay off in the satisfaction of the click of "Paste" and everything changes.
The problem with the Excel Analysis is getting it to update. If there has been no change to a feature, Creo will not recalculate it even when you regenerate. If there has been a change to a feature, Creo will recalculate that feature and everything below. The fact that you edit the Excel sheet does not register in Creo as a change in the feature, thus it will not regenerate. To get it to regenerate, you'll have to do one of two things:
And even after that, you might still have to hit the Regenerate button. I have a mapkey for triggering a "deep regeneration". What it does is search for the first feature of the part, selects it, goes into insert mode, then exits insert mode, followed by two regenerations. That does a full recalculation of the entire part (except the first feature, but that's likely a csys or plane).
It's annoying that Creo can't check for changes in the Excel file, but that's how it is. You have to force the software to recalculate the feature.
A different way of doing it would be to have an Excel output a text file, then use Pro/Program to read the text file for input parameters. You'll likely have to create a macro in Excel and a mapkey in Creo to get this to work well.