×
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

Spline node co-ordinates into Excel?

Spline node co-ordinates into Excel?

Spline node co-ordinates into Excel?

(OP)
Hello,

I would like to know if it is possible to extract the co-ordinates of a 2-D spline's nodes into an Excel spreadsheet.

I have tried using Analysis>Deviation>Gauge, this produces a notepad file of the co-ordinates and some other data, but is there a way to get only the co-ordinates into Excel directly?

Thanks very much
Rich

RE: Spline node co-ordinates into Excel?

What version of NX are you running?

Don't forget to specify that when asking a question, because people who come here are running versions from NX2-NX6

RE: Spline node co-ordinates into Excel?

(OP)
sorry! It is version 5.

RE: Spline node co-ordinates into Excel?

Some of us can still run V16 if we wanted to winky smile

No, there is no way to do this directly without the help of some custom application written in NX Open.  If you only wish to do this infrequently, going the Analysis route is probably the best way to go, but if it's something that you really do need to do a regular basis, investing in some NX Open effort might be appropriate.

John R. Baker, P.E.
Product 'Evangelist'
NX Design
Siemens PLM Software Inc.
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/

To an Engineer, the glass is twice as big as it needs to be.
 

RE: Spline node co-ordinates into Excel?

Hi Rich,

I think this question was posted (and answered) long back in this forum only.

Here is the procedure that I had read,

1) Created point set-> spline poles
2) Select points from screen, if the order is important select them in that order only. Now MB3 the first point selected, goto Properties -> Type PT (or any string), tick on "Add index to name", give OK.
You can see the points are renamed like PT1, PT2, PT3 . . . etc
3)Goto Tools->Spreadsheet

  Type PT1 in A1 (for example), PT2 in A2 and so on, to populate the column A.

  Select cells B1 through D1

  type = (for formula)

  type POINT(A1) then Ctrl+Shift+Enter

You can see X, Y and Z coordinates in the cells B1, C1 and D1 respectively.

Similarly, you can populate the other point coordinates.

RE: Spline node co-ordinates into Excel?

(OP)
That's great, thanks.

It would be really good to write an NX Open application for it, but there does not seem to be any method that I can record using journaling.

For the moment the create point set method works well.

On a related note, is there any way to find out the R-value identification (e.g. "HANDLE R-1485") required to refer to each spline in VB without recording a journal and inspecting it to view the code?

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