×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel to NX 7.5

Excel to NX 7.5

Excel to NX 7.5

(OP)
I can make x, y coordinates in excel of any curve
I need to learn, step by step, how to insert that Excel file into NX to make a curve

Any help on it?

RE: Excel to NX 7.5

(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.

RE: Excel to NX 7.5

...or if you know the equation, consider just using a "Law Curve" feature directly, without programming. smile

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)

RE: Excel to NX 7.5

want to Import the values of a spreadsheet into the expressions area

Cj Silver
Tooling Engineer
yesterday was... today is ... tomorrow MAYBE?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources