Skip to main content
S
Siege_engineer10-Marble
10-Marble
October 5, 2020
Solved

Location of Excel files and hole sketches used in a part for pattern and hole definition

  • October 5, 2020
  • 1 reply
  • 1732 views

Hello all,

 

I am using Excel for pattern definiton, this can be achived with the config option "part_table_editor excel", which is amazing. This is really handy, because I receive information about connector locations via the Excel format. I can specify angles and other dimensions.

 

For hole definition I plan to use the save sketch function. This way I can make sure that all the holes used for particular purpose are the same. Single source definition you could call it. This way I deny the possibilites of mistakes that one hole is a bit different then the other.

 

We use PTC Creo parametric 4.0 and Windchill. Now I was wondering, where are the Excel files and sketch files stored? Are they stored with the part? Meaning that if I release the part in windchill, the excel file and sketch file are also locked?

 

Kind regards

 

 

 

    Best answer by Chris3

    The Excel file is not stored.

     

    The Excel file is merely a translator. You can use it to edit the file but after you are done it refers to the original Creo format. For instance if you have any equations in Excel when you open it a second time the equations will be gone. This is because its not actually saving the native Excel file.

    1 reply

    M
    MartinHanak24-Ruby III
    24-Ruby III
    October 5, 2020
    @Siege_engineer wrote:

    Hello all,

     

    I am using Excel for pattern definiton, this can be achived with the config option "part_table_editor excel", which is amazing. This is really handy, because I receive information about connector locations via the Excel format. I can specify angles and other dimensions.

     

    For hole definition I plan to use the save sketch function. This way I can make sure that all the holes used for particular purpose are the same. Single source definition you could call it. This way I deny the possibilites of mistakes that one hole is a bit different then the other.

     

    We use PTC Creo parametric 4.0 and Windchill. Now I was wondering, where are the Excel files and sketch files stored? Are they stored with the part? Meaning that if I release the part in windchill, the excel file and sketch file are also locked?

     

    Kind regards

     

     

     

    Hi,

    YES, information related to part geometry is included in .prt file.

      C
      Chris321-Topaz IAnswer
      21-Topaz I
      October 5, 2020

      The Excel file is not stored.

       

      The Excel file is merely a translator. You can use it to edit the file but after you are done it refers to the original Creo format. For instance if you have any equations in Excel when you open it a second time the equations will be gone. This is because its not actually saving the native Excel file.

        Terms & ConditionsCookie settingsAccessibility statement