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
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?
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?
RE: Spline node co-ordinates into Excel?
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?
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?
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?