Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

external spreadsheet, the way to avoid refferences to the cell adress

Status
Not open for further replies.

PieterKruijf

Structural
Joined
May 21, 2012
Messages
2
Location
NL
Im using NX8, and making a model based on a external spreadsheet. like written below (old post of morotsprotdesign), I want to make it lose of the location of the spreadsheet.
Can anybody tell me how i have to write it.

I tried change it like this, but i dont works.

ug_excel_read( "\\DSGNT4\Users\JPdK\shipmodel_v3\20120508_expressions_opbouw_v1.xlsx", "H26" )---->
ug_excel_read( "20120508_expressions_opbouw_v1.xlsx", "H26" )

thanks!
Pieter



motorsportsdesign (Automotive) 30 Apr 05 17:02
You might try controlling the part from the spreadsheet and also making the analysis from the spreadsheet.

The way to do it in NX3.0.2 is to use ug_excell_read() in Design logic.

One additional good practice is to use named cells rather than referencing the cell address, this makes changes to the spreadsheet possible without changing anything in the part.
Jonathan T. Schmidt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top