Skip to main content
S
SM_979197310-Marble
10-Marble
June 15, 2021
Solved

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

  • June 15, 2021
  • 1 reply
  • 4467 views

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

Best answer by tbraxton

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

1 reply

tbraxton
22-Sapphire II
tbraxton22-Sapphire II
22-Sapphire II
June 15, 2021
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.
    S
    SM_979197310-MarbleAuthor
    10-Marble
    June 17, 2021

    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 II
    tbraxton22-Sapphire II
    22-Sapphire II
    June 17, 2021

    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

    Terms & ConditionsAccessibility statement