Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations IFRs 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
May 21, 2012
2
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
 
Replies continue below

Recommended for you

Status
Not open for further replies.

Part and Inventory Search

Sponsor