"Linking" excel to NX?
"Linking" excel to NX?
(OP)
I was wondering if there is a way to have NX reference an excel file so that when the excel file is altered, the sketch in NX is automatically changed as well. This would greatly help with parametrizing shapes. For example, I have equations that define a curve for a NACA airfoil. I want to be able to change the chord length or thickness, or any other variable that pertains to the shape of the airfoil and have NX automatically update the sketch that I have made relating to the .dat files obtained from excel.





RE: "Linking" excel to NX?
Now what this means is that while you can't FORCE NX to perform an update when you edit a spreadsheet, you can edit the spreadsheet, save it and the next time NX updates your model, it will read any new or changed values from the spreadsheet.
To find these functions, with the Expression dialog open, select the icon in the lower left area with the ' f(x) ' label. When you find a function that looks interesting, just select it in the list and either read the short description at the bottom the dialog or hit the 'Help' icon or press the ' F1 ' key to get the appropriate section from the user documentation to appear.
Anyway, I hope this helps.
John R. Baker, P.E.
Product 'Evangelist'
UGS NX Product Line
SIEMENS
UGS PLM Software
Cypress, CA
http://www.siemens.com/ugs
http://www.plmworld.org/museum/
RE: "Linking" excel to NX?
RE: "Linking" excel to NX?
RE: "Linking" excel to NX?
Now if you're talking about raw datapoints, you can also create both curves (splines) and b-surfaces by reading the points from a text file. Now there is no hard or even soft link between the NX part file and the data file, but you can update any existing spline/b-surface by editing the object and designating a new 'point definition file', which will then be used to update (not replace as an update will assure the user that all downstream relationships remain valid and associative).
John R. Baker, P.E.
Product 'Evangelist'
UGS NX Product Line
SIEMENS
UGS PLM Software
Cypress, CA
http://www.siemens.com/ugs
http://www.plmworld.org/museum/
RE: "Linking" excel to NX?
When is that bi-directionnal and live update foreseen with the good old NX ?
Many of the mid-range CAD software have the MS OLE for years now.
When we saw here what selfish direction NX took to manage tabulated notes on his own, the feeling was already that OLE could be forgotten for years ...
RE: "Linking" excel to NX?
I think your first option sounds what I might need....Im middly new to this software... how would I go about doing that? (and if you have time and the patience, could you also explain the methods for the 2nd option just in case?) thanks :)
RE: "Linking" excel to NX?
As far creating splines from a data file, go to Insert -> Curve -> Spline... (not Studio SPline) and select the 'Through Points' option and at the bottom of the dialog it will say 'Points from File'. Now at this point if you hit F1, the curve help page will come up but you will have to surf the links from there, but eventually you'll get to where it describes the format of the data file. And once a spline is created (and it doesn't really care how it was created or how many points it had or anything) you can edit the spline using the same method of using points from a file.
The format of a curve file is just X, Y, Z values in a space delimited format with an optional 3 additional fields for slope control at the point, in I, J, K vector parameters.
For a surface from points it's similar except that the file is formated as series of curve sets defined as points.
Again, of this formating and rules are covered in the documentation.
Now these curves/surfacs are not smart except for the fact that we append information showing the name and location of the data file used to create or edit them, but the software does not use that information to attempt to update the curve/surface if the data files are edited or anything like that, but of course you force that update usign the editing options anytime you wish.
Anyway, I hope that helps you get started.
John R. Baker, P.E.
Product 'Evangelist'
UGS NX Product Line
SIEMENS
UGS PLM Software
Cypress, CA
http://www.siemens.com/ugs
http://www.plmworld.org/museum/
RE: "Linking" excel to NX?
There's another way.
Use law curves and plug in your equations for the curve.
You'll get a smother result than fitting a spline through the points from the excel sheet.
Mark Benson
Aerodynamic Model Designer
RE: "Linking" excel to NX?