×
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

how to import Excel data i,e. points (x,y) ?? UG-NX4
3

how to import Excel data i,e. points (x,y) ?? UG-NX4

how to import Excel data i,e. points (x,y) ?? UG-NX4

(OP)
I have the data in excel format, consisting of (X,Y) coordinates,

how to import this coordinate data into cad model?

plz help me.
 

RE: how to import Excel data i,e. points (x,y) ?? UG-NX4

try:

1. create a worksheet consisting of only the X, Y, and Z columns of data (no headers).  If you don't have Z data, make a column of 0's equivalent in length to the X and Y data.

2. File > Save As > Save As Type > "Text (Tab Delimited)(*.txt)" > give it a name.  This will write out a text tab-delimited file with the data points.

3. Change the file extension of the file you just created from *.txt to *.dat

4. In NX (Modeling): Insert > Curve > Spline > Through Points > Points From File (select the *.dat file)

RE: how to import Excel data i,e. points (x,y) ?? UG-NX4

Ravi,

Potrero's answer is correct, but I'm not sure of your requirement from the wording of your question.

You can import point data from delimited text file into modelling using the steps he explains.

You can also create a table on a drawing of the co-ordinates using the drawing table function, and for that you can get the data from an excel file.

Cheers

Hudson

RE: how to import Excel data i,e. points (x,y) ?? UG-NX4

2
If you open your file in a simple text editor (eg notepad if you are on a PC), you will see that all the data is on one line. The method you used to export the point data apparently did not use the 'carriage return / linefeed' control character, rather it used some other delimiter that NX doesn't understand. If you have one point per line in the .dat file, it will work.

RE: how to import Excel data i,e. points (x,y) ?? UG-NX4

Hello,
I did the steps from potrero, and as a result I obtained an spline.
What I need is the points (non associative points).
I don't know if I had missed something.
Thanks

RE: how to import Excel data i,e. points (x,y) ?? UG-NX4

One way to get them back is by adding a 'point set'. Choose the 'spline defining points' option, pick the spline that was created through your points, and delete the spline.

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