Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

ravi1982

Mechanical
Apr 14, 2008
20
JP
I have the data in excel format, consisting of (X,Y) coordinates,

how to import this coordinate data into cad model?

plz help me.
 
Replies continue below

Recommended for you

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)
 
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
 
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top