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

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

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

SM_9791973
10-Marble

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

ACCEPTED SOLUTION

Accepted Solutions
tbraxton
22-Sapphire I
(To:SM_9791973)

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
tbraxton
22-Sapphire I
(To:SM_9791973)

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 

tbraxton
22-Sapphire I
(To:SM_9791973)

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
tbraxton
22-Sapphire I
(To:SM_9791973)

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
Announcements


Top Tags