Cancel
Showing results for 
Search instead for 
Did you mean: 

Re: Referencing Excel spreadsheet from Teamcenter

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

If you have an excel file that is referenced in several expressions, try creating a string expression with the path to the excel file, then the other expressions reference back to this one. When the excel file path changes, you only need to update one expression in the part file.

 

 

myExcelFile = "C:\path\to\excel\file.xslx"
exp1 = ug_cell_read(myExcelFile,...
exp2 = ug_cell_read(myExcelFile,...

 

Additionally, there is a journal here that will scan for excel references in your expressions and prompt for a new file or file location.

Re: Referencing Excel spreadsheet from Teamcenter

Siemens Esteemed Contributor Siemens Esteemed Contributor
Siemens Esteemed Contributor

Has there been any action on the Enhancement Request (ER) 1414636. can I view these requests on this website. if yes, then how? 


It's an older ER, reported against NX 3, with no duplicate requests.  I'd suggest contacting your local GTAC office and have them add you to the ER.  In doing so, the product manager is notified and it brings the ER up to a more current version of NX.  BTW, ER's cannot be searched by customers. 

 

Regards, Ben