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 JAE on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel to NX 7.5
- Thread starter NikonF6
- Start date
(1) From Excel, save the filer in CSV format.
(2) In NX, use File --> Import --> Points from File.
If you're planning to use the points to create a curve or a surface, and you know the equation of the curve or surface (because you used it to generate the points in Excel), then you might also consider using the functions Snap.Create.BezierCurveFit or Snap.Create.BezierPatchFit.
(2) In NX, use File --> Import --> Points from File.
If you're planning to use the points to create a curve or a surface, and you know the equation of the curve or surface (because you used it to generate the points in Excel), then you might also consider using the functions Snap.Create.BezierCurveFit or Snap.Create.BezierPatchFit.
TaylorAnderson
Mechanical
...or if you know the equation, consider just using a "Law Curve" feature directly, without programming. 
On what might be a related note, I had a customer ask about a similar scenario just this week at PLM World... He was wanting to:
a) import a set of points, create curves through them, and loft a surface through the curves
...and then be able to...
b) import a new set of locations for those same points, and have the curves and surface update to the new locations.
Sitting there in the Siemens booth, we did this in the end by:
1. Creating a set of point expressions first, representing his set of points
2. Creating a set of point features, each of which [associatively] referred to one of the point expressions
3. Creating a set of splines, each of which [associatively] referred to a set of point features
4. Creating a surface, referring [associatively] to the splines
...and then to replace the points, we edited the underlying values of the point expressions all at once by importing an expressions file (.exp, imported via the Expressions dialog.) This replaced the values of all of the point expressions, which updated the point features, which updated the splines, which updated the surface. And it all hangs together associatively like a champ.
We also explored using a journal to automate the creation of all of the point features, so that he could quickly copy and paste using his text editor instead of physically clicking through the creation of his moderately large set of points. The original expressions can similarly be created all at once using a .exp import file. (For the format of that baby, just export a few expressions and look at what you get.)
Does that make sense?
Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Product Engineering Software
Siemens Product Lifecycle Management Software Inc.
(Phoenix, Arizona)
On what might be a related note, I had a customer ask about a similar scenario just this week at PLM World... He was wanting to:
a) import a set of points, create curves through them, and loft a surface through the curves
...and then be able to...
b) import a new set of locations for those same points, and have the curves and surface update to the new locations.
Sitting there in the Siemens booth, we did this in the end by:
1. Creating a set of point expressions first, representing his set of points
2. Creating a set of point features, each of which [associatively] referred to one of the point expressions
3. Creating a set of splines, each of which [associatively] referred to a set of point features
4. Creating a surface, referring [associatively] to the splines
...and then to replace the points, we edited the underlying values of the point expressions all at once by importing an expressions file (.exp, imported via the Expressions dialog.) This replaced the values of all of the point expressions, which updated the point features, which updated the splines, which updated the surface. And it all hangs together associatively like a champ.
We also explored using a journal to automate the creation of all of the point features, so that he could quickly copy and paste using his text editor instead of physically clicking through the creation of his moderately large set of points. The original expressions can similarly be created all at once using a .exp import file. (For the format of that baby, just export a few expressions and look at what you get.)
Does that make sense?
Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Product Engineering Software
Siemens Product Lifecycle Management Software Inc.
(Phoenix, Arizona)
- Status
