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

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

How to keep relation of excel and Creo always irrespective of Excel File location

SM_9791973
9-Granite

How to keep relation of excel and Creo always irrespective of Excel File location

Hi,

I have created a 3rd model and I have created relations to drive its dimensions through excel.

I have called the excel into creo through Excel analysis tab available in analysis tab and created different Analysis feature so that it can take value from the excel & after that I have used that analysis feature in the relation so that it can drive its dimensions.

 

But once I changed the location of the Excel than the relations are not working. 

so, how to resolve this issue did I need to make new relations or how can we make the excel file location independent so that it does not affect the relations created inside the creo enviroment.

 

Any suggestions are welcomed...

 

Regards,

Shubham Mehta

1 ACCEPTED SOLUTION

Accepted Solutions

It seems a solution has been provided for you. Please respond to the solution post so that it is marked as solved.

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

View solution in original post

4 REPLIES 4

You can define a path using a config option and place your excel file in this location.
 
When you save an Excel analysis or create an Excel Analysis feature, the system saves the complete path to the .xls file. When you retrieve an Excel analysis or when an Excel Analysis feature is regenerated, the system searches for the .xls file in these locations in the following order:
• The original location of the file from which it was selected for the analysis
• The current working directory
• The directory specified by the configuration option excel_analysis_directory.
========================================
Involute Development, LLC
Consulting Engineers
Specialists in Creo Parametric

Thanks for the answer!

Could you help me by letting me know where I can define the path using the config option also where I can find that config option in the Creo?

 

Regards,

Shubham Mehta 

You can define the config option in your config.pro file. Here is the support link on config options.

https://support.ptc.com/help/creo/creo_pma/usascii/index.html#page/fundamentals%2Ffundamentals%2Ffund_five_sub%2FAbout_config_pro_options.html%23 

 

the config option can be found using the find option in the configuration editor. Use the full pathname for your folder.

 

The syntax will look like this

excel_analysis_directory full pathname

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

It seems a solution has been provided for you. Please respond to the solution post so that it is marked as solved.

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