Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

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

Siege_engineer
10-Marble

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

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

 

 

 

ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

2 REPLIES 2


@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.


Martin Hanák

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.

Announcements
NEW Creo+ Topics: Real-time Collaboration


Top Tags